Re: Performance Tuning and Disk Cache - Mailing list pgsql-performance

From Michael Stone
Subject Re: Performance Tuning and Disk Cache
Date
Msg-id 20070318184904.GL25629@mathom.us
Whole thread Raw
In response to Performance Tuning and Disk Cache  (Barry Moore <barry.moore@genetics.utah.edu>)
List pgsql-performance
On Sun, Mar 18, 2007 at 06:45:34AM -0600, Barry Moore wrote:
>Does anyone know how I can repeatedly run the same query in the
>"worst case scenario" of no postgres data in the disk cache (e.g.,
>clear the page cache or force it to be ignored)?

Depends on your OS. On linux you can run:
echo 1 > /proc/sys/vm/drop_caches

Mike Stone

pgsql-performance by date:

Previous
From: "Rangarajan Vasudevan"
Date:
Subject: Re: Performance Tuning and Disk Cache
Next
From: Tom Lane
Date:
Subject: Re: function call vs staright query