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&#

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