Re: SQL slower when running for the second time - Mailing list pgsql-performance

From Ron Johnson
Subject Re: SQL slower when running for the second time
Date
Msg-id 1062622143.7341.388.camel@haggis
Whole thread Raw
In response to SQL slower when running for the second time  (Rhaoni Chiu Pereira <rhaoni@sistemica.info>)
List pgsql-performance
On Wed, 2003-09-03 at 14:15, Rhaoni Chiu Pereira wrote:
> Hi List,
>
>    I trying to increase performance in my PostgreSQL but there is something
> wrong.    when I run this SQL for the first time it takes 1 min. 40 seconds to
> return, but when I run it for the second time it takes more than 2 minutes, and
> I should retunr faster than the first time.
>
> Does anyone have a advice ?

Is it a query or insert/update?

--
-----------------------------------------------------------------
Ron Johnson, Jr. ron.l.johnson@cox.net
Jefferson, LA USA

"Vanity, my favorite sin."
     Larry/John/Satan, "The Devil's Advocate"


pgsql-performance by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [ADMIN] SQL slower when running for the second time
Next
From: Rhaoni Chiu Pereira
Date:
Subject: Re: [ADMIN] SQL slower when running for the second time