Re: How i can empty the buffers of a db - Mailing list pgsql-general

From Josh Jore
Subject Re: How i can empty the buffers of a db
Date
Msg-id Pine.BSO.4.44.0208020859550.27261-100000@kitten.greentechnologist.org
Whole thread Raw
In response to Re: How i can empty the buffers of a db  (Tourtounis Sotiris <tourtoun@csd.uoc.gr>)
Responses Re: How i can empty the buffers of a db  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Arguile
Date:
Subject: Re: Selecting random row
Next
From: Tom Lane
Date:
Subject: Re: Questions regarding contrib/tsearch