clearing the buffer cache

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: clearing the buffer cache
Date: 2009-02-13 17:49:08
Message-ID: 20090213174908.GG32672@frubble.xen.chris-lamb.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
Sam http://samason.me.uk/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2009-02-13 17:49:52 Re: [findings] minimal open source e-commerce software for pg
Previous Message Greg Sabino Mullane 2009-02-13 16:59:52 Re: [findings] minimal open source e-commerce software for pg