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

2003-09-03 Thread Ron Johnson
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 m

[PERFORM] SQL slower when running for the second time

2003-09-03 Thread Rhaoni Chiu Pereira
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 anyo