Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 6522E9FBAB8; Thu, 26 Apr 2007 09:32:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 67441-07; Thu, 26 Apr 2007 09:32:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.potentialtech.com (internet.potentialtech.com [66.167.251.6]) by postgresql.org (Postfix) with ESMTP id 628909FBA78; Thu, 26 Apr 2007 09:32:13 -0300 (ADT) Received: from vanquish.pgh.priv.collaborativefusion.com (pr40.pitbpa0.pub.collaborativefusion.com [206.210.89.202]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.potentialtech.com (Postfix) with ESMTP id CBD92EBC78; Thu, 26 Apr 2007 08:32:11 -0400 (EDT) Date: Thu, 26 Apr 2007 08:32:11 -0400 From: Bill Moran To: "Sorin N. Ciolofan" Cc: , Subject: Re: [GENERAL] pg_buffercache view Message-Id: <20070426083211.06c1c990.wmoran@potentialtech.com> In-Reply-To: <20070426100013.5D3B68E40FC@mailhost.ics.forth.gr> References: <20070424090254.037f7996.wmoran@potentialtech.com> <20070426100013.5D3B68E40FC@mailhost.ics.forth.gr> X-Mailer: Sylpheed 2.3.1 (GTK+ 2.10.11; i386-portbld-freebsd6.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/245 X-Sequence-Number: 25309 In response to "Sorin N. Ciolofan" : > > Hello! > > Do you know which could be the reasons that could conduce an application to > not release the shared buffers, even after the application was shut down? > I noticed that only if a pg_ctl restart command is issued some of the > buffers are set free. The reason would be "by design." If the server flushes its cache every time the application restarts, the cache isn't going to be very effective. If PostgreSQL is using more shared buffers than you're comfortable with, reduce the shared_buffers setting in the config. That will allow the OS to decide how to use the memory instead. -- Bill Moran http://www.potentialtech.com