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

2011-05-03 Thread Joshua D. Drake
On 5/3/2011 7:33 AM, Simon Riggs wrote: Pleased to meet you Mark. If you post here, the above disclaimer is not effective. Right now your words are being copied across the internet... I believe our community needs to move past posting replies like this. It isn't even relevant to the context

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

2011-05-03 Thread Mark Johnson
Yes, understood and agreed. My mail server adds it automatically. I can manually remove it prior to sending to the mail list. -Mark -Original Message- From: Simon Riggs [mailto:si...@2ndquadrant.com] Sent: Tuesday, May 3, 2011 10:33 AM To: 'Mark Johnson' Cc: 'pgsql-admin', 'pgsql-general'

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

2011-05-03 Thread Peter Geoghegan
On 3 May 2011 16:49, Raymond O'Donnell wrote: > I don't want to start a flame war, but did they every have any legal force > in the first place? No. -- Peter Geoghegan       http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-general maili

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

2011-05-03 Thread Raymond O'Donnell
On 03/05/2011 16:08, Tom Lane wrote: Karsten Hilbert writes: On Tue, May 03, 2011 at 03:33:34PM +0100, Simon Riggs wrote: If you post here, the above disclaimer is not effective. Right now your words are being copied across the internet... By typing / selecting a public list address "writte

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

2011-05-03 Thread Tom Lane
Karsten Hilbert writes: > On Tue, May 03, 2011 at 03:33:34PM +0100, Simon Riggs wrote: >> If you post here, the above disclaimer is not effective. Right now >> your words are being copied across the internet... > By typing / selecting a public list address "written consent > of the author" can be

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

2011-05-03 Thread Simon Riggs
On Tue, May 3, 2011 at 2:30 PM, raghu ram wrote: >>> 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. >    

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

2011-05-03 Thread Karsten Hilbert
On Tue, May 03, 2011 at 03:33:34PM +0100, Simon Riggs wrote: > > The contents of this email may not be copied or forwarded in part or in > > whole without the express written consent of the author. > > Pleased to meet you Mark. > > If you post here, the above disclaimer is not effective. Right n

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

2011-05-03 Thread Mark Johnson
Is there a particular one of Oracle's memory clearning features you want to use in PostgreSQL? In Oracle you cannot flush the entire SGA without a restart, but you can flush three parts of the SGA using three separate commands. 1. In Oracle you can flush the redo buffer by issuing a COMMIT or by

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

2011-05-03 Thread Simon Riggs
On Tue, May 3, 2011 at 3:16 PM, Mark Johnson wrote: > The contents of this email may not be copied or forwarded in part or in > whole without the express written consent of the author. Pleased to meet you Mark. If you post here, the above disclaimer is not effective. Right now your words are be

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

2011-05-03 Thread Cédric Villemain
2011/5/3 Merlin Moncure : > On Tue, May 3, 2011 at 8:55 AM, Cédric Villemain > wrote: >> 2011/5/3 Merlin Moncure : >>> >>> no it will not, or at least there is no guarantee it will be.  the >>> only way to reset the buffers in that sense is to restart the database >>> (and even then they might not

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

2011-05-03 Thread Merlin Moncure
On Tue, May 3, 2011 at 8:55 AM, Cédric Villemain wrote: > 2011/5/3 Merlin Moncure : >> >> no it will not, or at least there is no guarantee it will be.  the >> only way to reset the buffers in that sense is to restart the database >> (and even then they might not be read from disk, because they co

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

2011-05-03 Thread Cédric Villemain
2011/5/3 Merlin Moncure : > On Tue, May 3, 2011 at 8:30 AM, raghu ram wrote: >> On Tue, May 3, 2011 at 6:01 PM, Raghavendra >> wrote: >>> >>> On Tue, May 3, 2011 at 5:37 PM, Simon Riggs wrote: On Tue, May 3, 2011 at 11:54 AM, raghu ram wrote: > It may be a silly questio

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

2011-05-03 Thread tv
> 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 >> wrote: >> >>> On Tue, May 3, 2011 at 11:54 AM, raghu ram >>> wrote: >>> >>> > It may be a silly question, still out of curiosity I want to know, is >>>

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

2011-05-03 Thread Merlin Moncure
On Tue, May 3, 2011 at 8:30 AM, raghu ram wrote: > On Tue, May 3, 2011 at 6:01 PM, Raghavendra > wrote: >> >> On Tue, May 3, 2011 at 5:37 PM, Simon Riggs wrote: >>> >>> On Tue, May 3, 2011 at 11:54 AM, raghu ram >>> wrote: >>> >>> > It may be a silly question, still out of curiosity I want to k

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

2011-05-03 Thread raghu ram
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 wrote: > >> On Tue, May 3, 2011 at 11:54 AM, raghu ram >> wrote: >> >> > It may be a silly question, still out of curiosity I want to know, is >> there >> > any

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

2011-05-03 Thread Raghavendra
On Tue, May 3, 2011 at 5:37 PM, Simon Riggs wrote: > On Tue, May 3, 2011 at 11:54 AM, raghu ram > 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 Oracl

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

2011-05-03 Thread Simon Riggs
On Tue, May 3, 2011 at 11:54 AM, raghu ram 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 i