Re: Can we Flush the Postgres Shared Memory ?

[Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx>]

On Tue, May 3, 2011 at 5:37 PM, Simon Riggs <simon@xxxxxxxxxxxxxxx> wrote:

On Tue, May 3, 2011 at 11:54 AM, raghu ram <raghuchennuru@xxxxxxxxx> wrote:

> It may be a silly question, still out of curiosity I want to know, is there
> any possible way to flush the Postgres Shared Memory without restarting the
> cluster.
> In Oracle, we can flush the SGA, can we get the same feature here..
> Thanks in Advance.

The CHECKPOINT command will do this for you.

This command will empty the PSM...

Best Regards,

Raghavendra

EnterpriseDB Corporation

Blog: http://raghavt.blogspot.com/