Re: Forcing using index instead of sequential scan?

On Sat, Jul 22, 2006 at 10:26:53AM -0700, Craig A. James wrote:
>This causes massive file-system activity and flushes all files that the 
>kernel has cached.  If you run this between each Postgres test (let it run 
>for a couple minutes), it gives you an apples-to-apples comparison between 
>successive benchmarks, and eliminates the effects of caching.

Assuming a system with small ram or an unusually large system 
installation. Unmounting is a much more realiable mechanism.

Mike Stone