Re: [PERFORM] [ADMIN] SQL slower when running for the second time

2003-09-03 Thread Rhaoni Chiu Pereira
<> Version of PostgreSQL? 7.3.2-3 on RedHat 9 <> <> Standard server configuration? Follow atached <> Hardware configuration? P4 1.7 Ghz 512 MB RAM DDR HD 20 GB 7200 RPM <> -Original Message- <> From: [EMAIL PROTECTED] <> [mailto:[EMAIL PROTECTED] Behalf Of Rha

Re: [PERFORM] [ADMIN] SQL slower when running for the second time

2003-09-03 Thread Peter Eisentraut
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 ret