X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5797BD1E91C for ; Wed, 24 Mar 2004 09:07:33 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 70036-07 for ; Wed, 24 Mar 2004 05:07:32 -0400 (AST) Received: from linda-1.paradise.net.nz (bm-1a.paradise.net.nz [202.0.58.20]) by svr1.postgresql.org (Postfix) with ESMTP id E0B95D1B905 for ; Wed, 24 Mar 2004 05:07:29 -0400 (AST) Received: from smtp-3.paradise.net.nz (smtp-3b.paradise.net.nz [202.0.32.212]) by linda-1.paradise.net.nz (Paradise.net.nz) with ESMTP id <0HV2009Z4PCILR@linda-1.paradise.net.nz> for pgsql-performance@postgresql.org; Wed, 24 Mar 2004 21:07:31 +1200 (NZST) Received: from paradise.net.nz (218-101-13-54.paradise.net.nz [218.101.13.54]) by smtp-3.paradise.net.nz (Postfix) with ESMTP id 80FC5AE7ED; Wed, 24 Mar 2004 21:07:30 +1200 (NZST) Date: Wed, 24 Mar 2004 21:09:02 +1200 From: Mark Kirkwood Subject: Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait! In-reply-to: <200403231455.08334.josh@agliodbs.com> To: josh@agliodbs.com Cc: Tom Lane , Darcy Buskermolen , pgsql-performance@postgresql.org Message-id: <4061502E.6030201@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.5) Gecko/20031213 References: <200403231248.34425.darcy@wavefire.com> <7083.1080080273@sss.pgh.pa.us> <200403231455.08334.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/343 X-Sequence-Number: 6199 Josh Berkus wrote: > Forget hyperthreading. Look at their postgresql.conf settings. 8mb shared > >mem, 16mb sort mem per connection for 512 connections, default >effective_cache_size. > > > Umm...its 64Mb shared buffers isn't it ? However agree completely with general thrust of message.... particularly the 16Mb of sort mem / connection - a very bad idea unless you are running a data warehouse box for only a few users (not 512 of them...) regards Mark