Andrew Sullivan <ajs@xxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
