| From: | Rhaoni Chiu Pereira <rhaoni(at)sistemica(dot)info> |
|---|---|
| To: | PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>, Lista PostgreSQL <pgsql-admin(at)postgresql(dot)org> |
| Subject: | SQL slower when running for the second time |
| Date: | 2003-09-03 19:15:58 |
| Message-ID: | 1062616558.3f563dee5ccd4@sistemica.info |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | creid | 2003-09-03 19:33:10 | Backup - Restore (pg-dump) |
| Previous Message | Yuji Shinozaki | 2003-09-03 18:11:15 | Dumping select tables (omitting tables) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vivek Khera | 2003-09-03 19:16:30 | Re: FreeBSD page size |
| Previous Message | Vivek Khera | 2003-09-03 15:48:22 | FreeBSD page size (was Re: The results of my PostgreSQL/filesystem performance tests) |