[ADMIN] 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

Re: [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 retunr