Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Jason TesserDate: 2004-12-23 16:09:51
Subject: Re: monitoring tools
Previous:From: Lonni J FriedmanDate: 2004-12-23 14:50:57
Subject: Re: monitoring tools

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group