Re: Performance Tuning and Disk Cache

From: "hubert depesz lubaczewski" <depesz(at)gmail(dot)com>
To: "Barry Moore" <barry(dot)moore(at)genetics(dot)utah(dot)edu>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance Tuning and Disk Cache
Date: 2007-03-18 13:18:19
Message-ID: 9e4684ce0703180618m33fe9ec4v3007a673d28df591@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 3/18/07, Barry Moore <barry(dot)moore(at)genetics(dot)utah(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message David Boreham 2007-03-18 15:26:37 Re: Performance Tuning and Disk Cache
Previous Message Barry Moore 2007-03-18 12:45:34 Performance Tuning and Disk Cache