Postgres Pro
Downloads
Home   >   mailing lists

Re: Can we Flush the Postgres Shared Memory ? - Mailing list pgsql-admin

From Simon Riggs
Subject Re: Can we Flush the Postgres Shared Memory ?
Date
Msg-id BANLkTikUYxYXUv-FsDQtN0CYiqkJ1BorXw@mail.gmail.com
Whole thread Raw
In response to Can we Flush the Postgres Shared Memory ?  (raghu ram <raghuchennuru@gmail.com>)
Responses Re: Can we Flush the Postgres Shared Memory ?  (Raghavendra <raghavendra.rao@enterprisedb.com>)
List pgsql-admin
Tree view 
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.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-admin by date:

Previous
From: raghu ram
Date:
Subject: Can we Flush the Postgres Shared Memory ?
Next
From: Raghavendra
Date:
Subject: Re: Can we Flush the Postgres Shared Memory ?