SQL slower when running for the second time
SQL slower when running for the second time
От:
Rhaoni Chiu Pereira <rhaoni@sistemica.info>
Дата:
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
Re: SQL slower when running for the second time
От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
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