Search Postgresql Archives

Re: [ADMIN] Can we Flush the Postgres Shared Memory ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Tue, May 3, 2011 at 6:01 PM, Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx> wrote:

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.



According to PostgreSQL documentation, whenever you execute "CHECKPOINT" in the database,it will flush the modified data files presented in the Shared Buffers retuned to the Disk.

           http://www.postgresql.org/docs/9.0/static/sql-checkpoint.html 

Is this clears the entire shared memory cache and same time,if i execute fresh SQL statement, Data will be retuned from disk??

 

--Raghu Ram



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux