Re: Forcing using index instead of sequential scan? - Mailing list pgsql-performance

From Michael Stone
Subject Re: Forcing using index instead of sequential scan?
Date
Msg-id 20060723110724.GU8069@mathom.us
Whole thread Raw
In response to Re: Forcing using index instead of sequential scan?  ("Craig A. James" <cjames@modgraph-usa.com>)
Responses Re: Forcing using index instead of sequential scan?  ("Craig A. James" <cjames@modgraph-usa.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Forcing using index instead of sequential scan?
Next
From: "Craig A. James"
Date:
Subject: Re: Forcing using index instead of sequential scan?