Re: Very slow stored proc

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Együd Csaba (Freemail) <csegyud(at)freemail(dot)hu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Very slow stored proc
Date: 2004-12-23 14:57:44
Message-ID: 20041223145744.GD19065@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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[(at)]dcc(dot)uchile(dot)cl>)
"La tristeza es un muro entre dos jardines" (Khalil Gibran)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jason Tesser 2004-12-23 16:09:51 Re: monitoring tools
Previous Message Lonni J Friedman 2004-12-23 14:50:57 Re: monitoring tools