Postgres Pro
Downloads
Home   >   mailing lists

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

From Brad Nicholson
Subject Re: clearing the buffer cache
Date
Msg-id 1234547541.6432.7.camel@bnicholson-desktop
Whole thread Raw
In response to clearing the buffer cache  (Sam Mason <sam@samason.me.uk>)
Responses Re: clearing the buffer cache  (Sam Mason <sam@samason.me.uk>)
Re: clearing the buffer cache  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
Tree view 
On Fri, 2009-02-13 at 17:49 +0000, Sam Mason wrote:
> Hi,
>
> I was doing some performance checks and wondered what the best way to
> clear out the shared buffers is?  With the recent improvements in buffer
> management it appears a simple SELECT * FROM large_table; doesn't help
> here!
>
> I was hoping for a function I could call, or maybe some variable I write
> to, that would cause the contents to be invalidated.

Restart the database.
--
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: [findings] minimal open source e-commerce software for pg
Next
From: Sam Mason
Date:
Subject: Re: clearing the buffer cache