| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Rhaoni Chiu Pereira <rhaoni(at)sistemica(dot)info> |
| Cc: | PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>, Lista PostgreSQL <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: SQL slower when running for the second time |
| Date: | 2003-09-03 20:03:11 |
| Message-ID: | Pine.LNX.4.44.0309032202450.1035-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
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(at)gmx(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-09-03 20:31:41 | Re: language "plpgsql" does not exist |
| Previous Message | Peter Eisentraut | 2003-09-03 20:01:52 | Re: Backup - Restore (pg-dump) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2003-09-03 20:32:37 | Re: FreeBSD page size |
| Previous Message | Vivek Khera | 2003-09-03 19:41:25 | Re: FreeBSD page size |