On Tue, May 3, 2011 at 6:01 PM, Raghavendra <
raghavendra....@enterprisedb.com> wrote:
>
> On Tue, May 3, 2011 at 5:37 PM, Simon Riggs <si...@2ndquadrant.com> wrote:
>
>> On Tue, May 3, 2011 at 11:54 AM, raghu ram <raghuchenn...@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.
>>
>
>
>
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
