From owner-freebsd-database@FreeBSD.ORG  Sun Oct 22 17:03:50 2006
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
X-Original-To: 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 28B5316A412;
	Sun, 22 Oct 2006 17:03:50 +0000 (UTC) (envelope-from vdemart1@tin.it)
Received: from vsmtp12.tin.it (vsmtp12.tin.it [212.216.176.206])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 236C343D64;
	Sun, 22 Oct 2006 17:03:42 +0000 (GMT) (envelope-from vdemart1@tin.it)
Received: from [10.155.100.8] (87.20.229.20) by vsmtp12.tin.it (7.2.072.1)
	(authenticated as vdemart1@tin.it)
	id 452629DE0070DAF2; Sun, 22 Oct 2006 19:03:36 +0200
From: vittorio <vdemart1@tin.it>
To: freebsd-performance@freebsd.org,
 freebsd-database@freebsd.org
Date: Sun, 22 Oct 2006 19:03:06 +0000
User-Agent: KMail/1.9.4
MIME-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200610221903.06526.vdemart1@tin.it>
Cc: 
Subject: Improving performance of postgresql
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.5
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: Sun, 22 Oct 2006 17:03:50 -0000

Under freebsd 6.1 on  a pentium 4 with 256 MB I compiled and installed a 
postgresql (now 8.0.8) server which has been running wonderfully.

I tailored the conf files to tune the server with my hardware according to the 
many suggestions I read in the net which are OS-independent that is that 
apply to any *nix (or better linux-centric).

Now I would like to know if for a postgresql server there are settings more ** 
freebsd specif ic ** to improve performance.

Ciao
Vittorio.