Date: Tue, 26 Aug 2003 14:38:29 -0400 From: Paul Pathiakis <paul@pathiakis.com> To: "Marc G. Fournier" <scrappy@hub.org>, Sean Chittenden <sean@chittenden.org> Cc: freebsd-performance@freebsd.org Subject: Re: Tuning Postgresql on FreeBSD 5.1 Message-ID: <200308261438.29700.paul@pathiakis.com> In-Reply-To: <20030826013926.E691@ganymede.hub.org> References: <200308250929.32143.paul@pathiakis.com> <20030826030527.GB1514@perrin.nxad.com> <20030826013926.E691@ganymede.hub.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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" ...
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200308261438.29700.paul>