Skip site navigation (1) Skip section navigation (2)

Re: Flush Shared Buffer Cache

From: Chander Ganesan <chander(at)otg-nc(dot)com>
To: Suvankar Roy <suvankar(dot)roy(at)tcs(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Flush Shared Buffer Cache
Date: 2009-07-15 15:18:22
Message-ID: 4A5DF33E.2060902@otg-nc.com (view raw or flat)
Thread:
Lists: pgsql-admin
Suvankar Roy wrote:
>
> Hi,
>
> Can anyone help me out with how to flush out Shared Buffer Cache in 
> Postgres.
>
> One way would be to restart the database, but I would like to avoid that.
AFAIK, that's the only way. 

Is there a reason that you need to dump the shared buffers?  Perhaps if 
we knew what you were trying to accomplish we could provide you with a 
suitable solution that doesn't require a restart...

-- 
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC  27560
919-463-0999/877-258-8987
http://www.otg-nc.com
Expert PostgreSQL, PostGIS, and other Open Source training delivered worldwide.


In response to

Responses

pgsql-admin by date

Next:From: Chander GanesanDate: 2009-07-15 15:22:18
Subject: Re: Networking request
Previous:From: Scott MeadDate: 2009-07-15 15:17:28
Subject: Re: PostgreSQL/PAM problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group