From owner-freebsd-database@FreeBSD.ORG  Tue Aug 26 11:39:18 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 B11DF16A4BF; Tue, 26 Aug 2003 11:39:18 -0700 (PDT)
Received: from abe.micropat.com (abe.micropat.com [204.17.221.119])
	by mx1.FreeBSD.org (Postfix) with ESMTP
	id A043243F85; Tue, 26 Aug 2003 11:39:13 -0700 (PDT)
	(envelope-from paul@pathiakis.com)
Received: from 10.0.0.101 ([204.17.221.104]) by abe.micropat.com
          (Netscape Messaging Server 4.15) with ESMTP id HK8OTJ00.PVZ;
          Tue, 26 Aug 2003 14:32:07 -0400 
From: Paul Pathiakis <paul@pathiakis.com>
To: "Marc G. Fournier" <scrappy@hub.org>,
	Sean Chittenden <sean@chittenden.org>
Date: Tue, 26 Aug 2003 14:38:29 -0400
User-Agent: KMail/1.5.3
References: <200308250929.32143.paul@pathiakis.com>
	<20030826030527.GB1514@perrin.nxad.com> <20030826013926.E691@ganymede.hub.org>
In-Reply-To: <20030826013926.E691@ganymede.hub.org>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200308261438.29700.paul@pathiakis.com>
cc: freebsd-database@freebsd.org
cc: freebsd-performance@freebsd.org
Subject: Re: Tuning Postgresql on FreeBSD 5.1
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
Reply-To: paul@pathiakis.com
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: Tue, 26 Aug 2003 18:39:18 -0000

Marc,

	I've tried disabling HTT in the BIOS (it's an Intel board).  I've disable 
HTT, saved the changes and the kernel is still seeing 4 CPUs when it boots.  
Any ideas?

	Thanks,

	P.


On Tuesday 26 August 2003 12:44 am, Marc G. Fournier wrote:
> > > Again, the machine is a twin 2.8 Xeon HTT machine.  HTT is turned on
> > > and the machine sees 4 cpus.
> >
> > Have you played with toggling the sysctl machdep.cpu_idle_hlt?
>
> In fact, disabled HTT altogether ... I have a machine with pretty much the
> same specs (2.4 vs 2.8 Xeon's) and I found performance noticeably improved
> with HTT disabled ... not just with processes, but with interactive
> sessions as well ...
>
> > >From your postgresql.conf:
> > >
> > > shared_buffers = 48000          # min max_connections*2 or 16, 8KB each
> >
> > WHOA!  This is too high by a factor of about 10.  You probably want a
> > shared buffers set to 4096.
>
> Why?  If you have the memory and all that ... All my production servers
> run:
>
> /usr/local/bin/postmaster -B 40960 -N 512 -i -p 5432
> -D/usr/local/pgsql/5432 -S (postgres)
>
> > > sort_mem = 32768                # min 64, size in KB
> >
> > This also seems high, divide by 8 and you're at a more reasonable
> > level.
>
> Again, depends on alot of things here ... if he only has the one
> connection to the DB, allowing for 32M of RAM to be used for sorting isn't
> a bad thing, since it keeps the sorts off of the hard drive ... that is
> one stat that I wish we kept somehow ... "max sort size" ...