Postgres Pro
Downloads
Home   >   mailing lists

Re: Query only slow on first run - Mailing list pgsql-performance

From Tom Lane
Subject Re: Query only slow on first run
Date
Msg-id 23999.1196184368@sss.pgh.pa.us
Whole thread Raw
In response to Re: Query only slow on first run  (Andrew Sullivan <ajs@crankycanuck.ca>)
Responses Re: Query only slow on first run  (cluster <skrald@amossen.dk>)
List pgsql-performance
Tree view 
Andrew Sullivan <ajs@crankycanuck.ca> writes:
> On Tue, Nov 27, 2007 at 05:33:36PM +0100, cluster wrote:
>> I have a query that takes about 7000 ms in average to complete the first
>> time it runs. Subsequent runs complete in only 50 ms. That is more than
>> a factor 100 faster! How can I make the query perform good in the first
>> run too?

> Probably by buying much faster disk hardware.

Or buy more RAM, so that the data can stay cached.

            regards, tom lane

pgsql-performance by date:

Previous
From: Kevin Kempter
Date:
Subject: Re: Query only slow on first run
Next
From: Matthew
Date:
Subject: GiST indexing tuples