Re: Forcing using index instead of sequential scan?

From: Michael Stone <mstone+postgres(at)mathom(dot)us>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Forcing using index instead of sequential scan?
Date: 2006-07-23 11:07:26
Message-ID: 20060723110724.GU8069@mathom.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Craig A. James 2006-07-23 14:03:59 Re: Forcing using index instead of sequential scan?
Previous Message Mark Kirkwood 2006-07-23 03:39:21 Re: Forcing using index instead of sequential scan?