Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Eisentraut
Subject Re: [ADMIN] SQL slower when running for the second time
Date
Msg-id Pine.LNX.4.44.0309032202450.1035-100000@peter.localdomain
Whole thread Raw
In response to SQL slower when running for the second time  (Rhaoni Chiu Pereira <rhaoni@sistemica.info>)
List pgsql-performance
Tree view 
Rhaoni Chiu Pereira writes:

>    I trying to increase performance in my PostgreSQL but there is something
> wrong.    when I run this SQL for the first time

Which SQL?

> 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.

What happens the third time?

--
Peter Eisentraut   peter_e@gmx.net

pgsql-performance by date:

Previous
From: Vivek Khera
Date:
Subject: Re: FreeBSD page size
Next
From: Ron Johnson
Date:
Subject: Re: SQL slower when running for the second time