Re: clearing the buffer cache - Mailing list pgsql-general

From Chris Mayfield
Subject Re: clearing the buffer cache
Date
Msg-id gnc34m$1eku$1@news.hub.org
Whole thread Raw
In response to Re: clearing the buffer cache  (Sam Mason <sam@samason.me.uk>)
Responses Re: clearing the buffer cache
List pgsql-general
> With recent versions of Linux you can flush the system's buffer cache by
> doing:
>
>   # echo 3 > /proc/sys/vm/drop_caches

You can also try something like this:
http://wiki.services.openoffice.org/wiki/Cold-start-simulator

Shutting down the server and running fillmem has worked for me, but that
might take too long in your situation of thousands of small queries. But
I guess "SELECT * FROM large_table" would have taken just as long anyway.

--Chris

pgsql-general by date:

Previous
From: Scara Maccai
Date:
Subject: Re: left outer join without rows from "left" table
Next
From: Sam Mason
Date:
Subject: Re: ask: select right(column) ???