Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group