From owner-freebsd-database@FreeBSD.ORG  Fri Jul 25 21:22:24 2003
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP
	id 5967B37B401; Fri, 25 Jul 2003 21:22:24 -0700 (PDT)
Received: from misery.sdf.com (misery.sdf.com [207.200.153.226])
	by mx1.FreeBSD.org (Postfix) with ESMTP
	id 9581C43F3F; Fri, 25 Jul 2003 21:22:22 -0700 (PDT)
	(envelope-from tom@sdf.com)
Received: from tom (helo=localhost)
	by misery.sdf.com with local-esmtp (Exim 2.12 #1)
	id 19gEol-0003pK-00; Fri, 25 Jul 2003 19:29:55 -0700
Date: Fri, 25 Jul 2003 19:29:50 -0700 (PDT)
From: Tom Samplonius <tom@sdf.com>
To: "Michael E. Conlen" <meconlen@obfuscated.net>
In-Reply-To: <FGEGKFPBILMAPHFOHIIFEECPDPAA.meconlen@obfuscated.net>
Message-ID: <Pine.BSF.4.05.10307251925430.16986-100000@misery.sdf.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
cc: freebsd-database@freebsd.org
cc: freebsd-performance@freebsd.org
cc: Christopher Weimann <cweimann@k12hq.com>
Subject: RE: Tuning for PostGreSQL Database
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 26 Jul 2003 04:22:24 -0000


On Fri, 25 Jul 2003, Michael E. Conlen wrote:

> I was concerned about the disk cache because of this link
> 
> http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html#shbuf
> 
> which says...

<inaccurate PostgreSQL info deleted>

> But now that I have looked a bit more I see that this link
> 
> http://www.postgresql.org/docs/aw_pgsql_book/hw_performance/node6.html
...

  I would go with the information from the PostgreSQL site.  It is at
least reviewed by the developers (if not written by them).


Tom