Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Can we Flush the Postgres Shared Memory ? - Mailing list pgsql-novice

From Raghavendra
Subject Re: [ADMIN] Can we Flush the Postgres Shared Memory ?
Date
Msg-id BANLkTi=VtowCtuQTmjmnTiEk7mYAY8X2dw@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] Can we Flush the Postgres Shared Memory ?  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: [ADMIN] Can we Flush the Postgres Shared Memory ?  (raghu ram <raghuchennuru@gmail.com>)
List pgsql-novice
Tree view

On Tue, May 3, 2011 at 5:37 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
On Tue, May 3, 2011 at 11:54 AM, raghu ram <raghuchennuru@gmail.com> 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


pgsql-novice by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [ADMIN] Can we Flush the Postgres Shared Memory ?
Next
From: raghu ram
Date:
Subject: Re: [ADMIN] Can we Flush the Postgres Shared Memory ?