Re: Performance Tuning and Disk Cache

["hubert depesz lubaczewski" <depesz(at)gmail(dot)com>]

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