clearing the buffer cache

Поиск
Список
Период
Сортировка
От Sam Mason
Тема clearing the buffer cache
Дата
Msg-id 20090213174908.GG32672@frubble.xen.chris-lamb.co.uk
обсуждение исходный текст
Ответы Re: clearing the buffer cache  (Brad Nicholson <bnichols@ca.afilias.info>)
Re: clearing the buffer cache  (Greg Smith <gsmith@gregsmith.com>)
Список 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/

В списке pgsql-general по дате отправления:

Предыдущее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: [findings] minimal open source e-commerce software for pg
Следующее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: Re: [findings] minimal open source e-commerce software for pg