Re: Very slow stored proc

Dear Alvarao,
would you please so kind explaining me your opinion in details.

thanks,
-- Csaba


-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Alvaro Herrera
Sent: Thursday, December 23, 2004 3:58 PM
To: Együd Csaba (Freemail)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Very slow stored proc

On Thu, Dec 23, 2004 at 10:51:46AM +0100, Együd Csaba (Freemail) wrote:

Hi,

> I've got it. Not the date handling is slow but the string handling.
> Eliminating the huge string buffer and running all the inserts row by
> row, the overall running time is 12 sec.
> So as a conclusion never use large strings in plpgsql functions.

I wonder why you are creating a table at all, when you could probably use a
SRF instead in the queries where you are using such table.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>) "La tristeza es un muro entre
dos jardines" (Khalil Gibran)

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings



--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 2004.12.22.


--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 2004.12.22.


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 2004.12.22.




--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 2004.12.22.