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 (<[EMAIL PROTECTED]>) "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
