Re: How i can empty the buffers of a db

On Fri, 2 Aug 2002, Tourtounis Sotiris wrote:

> i mean the amount of buffers that you state when you load the postmaster
> on a machine - i don't know if i express it proper in order to understand
> !!!

I take it you mean the shared memory buffer then[1]. You stop PostgreSQL.
If you *still* need to clear the shared memory then you read ipcclean(1).

[1] -B nbuffers
Sets the number of shared buffers for use by the server processes. This
value defaults to 64 buffers, where each buffer is 8 kB.

Joshua b. Jore ; http://www.greentechnologist.org