Postgres Pro
Downloads
Home   >   mailing lists

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

From Rhaoni Chiu Pereira
Subject SQL slower when running for the second time
Date
Msg-id 1062616558.3f563dee5ccd4@sistemica.info
Whole thread Raw
Responses Re: [ADMIN] SQL slower when running for the second time  (Peter Eisentraut <peter_e@gmx.net>)
Re: SQL slower when running for the second time  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-performance
Tree view 
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 ?

Atenciosamente,

Rhaoni Chiu Pereira
Sistêmica Computadores

Visite-nos na Web: http://sistemica.info
Fone/Fax : +55 51 3328 1122

pgsql-performance by date:

Previous
From: Vivek Khera
Date:
Subject: FreeBSD page size (was Re: The results of my PostgreSQL/filesystem performance tests)
Next
From: Vivek Khera
Date:
Subject: Re: FreeBSD page size