Re: Query only slow on first run

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

cluster <skrald(at)amossen(dot)dk> writes:
> I could really use any kind of suggestion on how to improve the query in 
> order to make it scale better for large data sets The 6-7000 ms for a 
> clean run is really a showstopper. Need to get it below 70 ms somehow.

Buy a faster disk?

You're essentially asking for a random sample of data that is not
currently in memory.  You're not going to get that without some I/O.

			regards, tom lane