Re: clearing the buffer cache
| От | Brad Nicholson |
|---|---|
| Тема | Re: clearing the buffer cache |
| Дата | |
| Msg-id | 1234547541.6432.7.camel@bnicholson-desktop обсуждение исходный текст |
| Ответ на | clearing the buffer cache (Sam Mason <sam@samason.me.uk>) |
| Ответы |
Re: clearing the buffer cache
Re: clearing the buffer cache |
| Список | pgsql-general |
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 по дате отправления: