| From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
|---|---|
| To: | PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: SQL slower when running for the second time |
| Date: | 2003-09-03 20:49:03 |
| Message-ID: | 1062622143.7341.388.camel@haggis |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
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 minutes, and
> I should retunr faster than the first time.
>
> Does anyone have a advice ?
Is it a query or insert/update?
--
-----------------------------------------------------------------
Ron Johnson, Jr. ron(dot)l(dot)johnson(at)cox(dot)net
Jefferson, LA USA
"Vanity, my favorite sin."
Larry/John/Satan, "The Devil's Advocate"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Huynh | 2003-09-03 22:21:53 | Re: Problems Starting Postgres as a Service |
| Previous Message | Bruce Momjian | 2003-09-03 20:31:41 | Re: language "plpgsql" does not exist |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-09-03 23:29:24 | Re: FreeBSD page size |
| Previous Message | Rhaoni Chiu Pereira | 2003-09-03 20:44:12 | Re: [ADMIN] SQL slower when running for the second time |