Re: 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)