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