X-Original-To: pgsql-performance-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id E5D599FB2C7
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon,  4 Sep 2006 09:12:58 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 66243-03-2
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon,  4 Sep 2006 09:12:48 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail.mnc.ch (62-2-77-205.static.cablecom.ch [62.2.77.205])
	by postgresql.org (Postfix) with ESMTP id D1A719FB2DC
	for <pgsql-performance@postgresql.org>;
	Mon,  4 Sep 2006 09:10:40 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by mail.mnc.ch (Postfix) with ESMTP id 4F03CA8302;
	Mon,  4 Sep 2006 14:16:00 +0200 (CEST)
Received: from mail.mnc.ch ([127.0.0.1])
	by localhost (mail.test.lan [127.0.0.1]) (amavisd-new,
	port 10025) with ESMTP
	id 01454-06; Mon,  4 Sep 2006 14:15:58 +0200 (CEST)
Received: from meuh.mnc.lan (62-2-77-204.static.cablecom.ch [62.2.77.204])
	by mail.mnc.ch (Postfix) with ESMTP id EB9D8A82C6;
	Mon,  4 Sep 2006 14:15:58 +0200 (CEST)
Received: by meuh.mnc.lan (Postfix, from userid 1000)
	id 81EB91836F4; Mon,  4 Sep 2006 14:10:14 +0200 (CEST)
To: "Merlin Moncure" <mmoncure@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: increasing shared buffers: how much should be removed from OS
	filesystem cache?
References: <87veo7a5dn.fsf@meuh.mnc.lan>
	<b42b73150609011249p612ccd27gbb5ee4db9b5b10f4@mail.gmail.com>
X-Hashcash: 
 1:20:060904:mmoncure@gmail.com::PkUVHbtC3WqGw/QJ:0000000000000000000000000000000000000000000AeF9
X-Hashcash: 
 1:20:060904:pgsql-performance@postgresql.org::6am9g0FufJryL/Te:000000000000000000000000000008O3G
From: Guillaume Cottenceau <gc@mnc.ch>
Date: 04 Sep 2006 14:10:14 +0200
In-Reply-To: <b42b73150609011249p612ccd27gbb5ee4db9b5b10f4@mail.gmail.com>
Message-ID: <87ac5fhly1.fsf@meuh.mnc.lan>
Lines: 21
User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.4
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: amavisd-new at mnc.ch
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.182 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200609/20
X-Sequence-Number: 20706

"Merlin Moncure" <mmoncure 'at' gmail.com> writes:

> On 01 Sep 2006 19:00:52 +0200, Guillaume Cottenceau <gc@mnc.ch> wrote:
> > Hi,
> >
> > I've been looking at the results from the pg_statio* tables, to
> > view the impact of increasing the shared buffers to increase
> > performance.
> >
> 
> I think 'shared buffers' is one of the most overrated settings from a
> performance standpoint.  however you must ensure there is enough for
> things the server does besides caching.  It used to be a bigger deal

"Beside caching".. It's unfornatunate that the documentation on
pg.org is very vague about the actual use(s) of the shared
buffers :/

-- 
Guillaume Cottenceau
Create your personal SMS or WAP Service - visit http://mobilefriends.ch/