Re: Query only slow on first run

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Andrew Sullivan <ajs(at)crankycanuck(dot)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