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

From hubert depesz lubaczewski
Subject Re: Performance Tuning and Disk Cache
Date
Msg-id 9e4684ce0703180618m33fe9ec4v3007a673d28df591@mail.gmail.com
Whole thread Raw
In response to Performance Tuning and Disk Cache  (Barry Moore <barry.moore@genetics.utah.edu>)
List pgsql-performance
On 3/18/07, Barry Moore <barry.moore@genetics.utah.edu> 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)?

try to disconnect from postgresql, reconnect, rerun the query.
if it doesn't help - you can try unmounting filesystem which contains
postgresql data, and remounting it again. of course with postgresql
shutdown.

depesz

--
http://www.depesz.com/ - nowy, lepszy depesz

pgsql-performance by date:

Previous
From: Barry Moore
Date:
Subject: Performance Tuning and Disk Cache
Next
From: David Boreham
Date:
Subject: Re: Performance Tuning and Disk Cache