Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 40E5A9FB250 for ; Tue, 14 Nov 2006 10:17:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 79003-07 for ; Tue, 14 Nov 2006 14:17:11 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175]) by postgresql.org (Postfix) with ESMTP id 135199FB232 for ; Tue, 14 Nov 2006 10:17:10 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so1171292ugf for ; Tue, 14 Nov 2006 06:17:09 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=bQRf40/0NpKoxKogvCB1qjvjaUfcKYx741GFiz4oH1aYq+qUTv4myUJA9hHRnGtGx/o91H9nwJ+/6KfAKci2YM3aS3BDC5AbFvPC49VICtOGZ+/FkJCJXg5M60hLdUVT2PKi2eigajq2rUPaqKqTOYn84cMY0UdqzpTTIqGpTYM= Received: by 10.78.146.11 with SMTP id t11mr1099967hud.1163513829146; Tue, 14 Nov 2006 06:17:09 -0800 (PST) Received: by 10.78.45.3 with HTTP; Tue, 14 Nov 2006 06:17:08 -0800 (PST) Message-ID: Date: Tue, 14 Nov 2006 09:17:08 -0500 From: "Merlin Moncure" To: "Cosimo Streppone" Subject: Re: Context switch storm Cc: "Richard Huxton" , "Postgresql Performance list" In-Reply-To: <455991B0.6070209@streppone.it> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <454B3B75.6@archonet.com> <454B3EDC.3090502@streppone.it> <454B4438.9080105@archonet.com> <455991B0.6070209@streppone.it> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/101 X-Sequence-Number: 21871 On 11/14/06, Cosimo Streppone wrote: > I must say I lowered "shared_buffers" to 8192, as it was before. > I tried raising it to 16384, but I can't seem to find a relationship > between shared_buffers and performance level for this server. My findings are pretty much the same here. I don't see any link between shared buffers and performance. I'm still looking for hard evidence to rebut this point. Lower shared buffers leaves more memory for what really matters, which is sorting. > > Well, the client I saw it with just bought a dual-opteron server and > > used their quad-Xeon for something else. However, I do remember that 8.1 > > seemed better than 7.4 before they switched. Part of that might just > > have been better query-planning and other efficiences though. > > An upgrade to 8.1 is definitely the way to go. > Any 8.0 - 8.1 migration advice? If you are getting ready to stage an upgrade, you definately will want to test on 8.2 and 8.1. 8.2 might give you better results in the lab, and has some nice features. merlin