Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 628EB9FB54C for ; Fri, 2 Mar 2007 14:00:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 43179-05 for ; Fri, 2 Mar 2007 14:00:03 -0400 (AST) X-Greylist: delayed 00:14:17.436451 by SQLgrey-1.7.4 Received: from smtp-out.kontent.com (smtp-out001.kontent.com [81.88.40.215]) by postgresql.org (Postfix) with ESMTP id 1D61B9FB3B4 for ; Fri, 2 Mar 2007 14:00:03 -0400 (AST) Received: from tau.alphaset.de (static-87-79-200-24.netcologne.de [87.79.200.24]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by smtp-out.kontent.com (Postfix) with ESMTP id E2DB737C132 for ; Fri, 2 Mar 2007 18:45:44 +0100 (CET) Received: from tau.alphaset.de (tau.alphaset.de [192.168.42.1]) by tau.alphaset.de (8.13.4/8.13.4) with ESMTP id l22HjiRv004641 for ; Fri, 2 Mar 2007 18:45:44 +0100 Received: from localhost (localhost [[UNIX: localhost]]) by tau.alphaset.de (8.13.4/8.13.6/Submit) id l22Hjiox004638 for pgsql-performance@postgresql.org; Fri, 2 Mar 2007 18:45:44 +0100 From: Anton Rommerskirchen Reply-To: atr@atrsoft.de Organization: ATRSoft GmbH To: pgsql-performance@postgresql.org Subject: Re: strange performance regression between 7.4 and 8.1 Date: Fri, 2 Mar 2007 18:45:44 +0100 User-Agent: KMail/1.8 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200703021845.44225.atr@atrsoft.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200703/65 X-Sequence-Number: 23470 Am Donnerstag 01 M=E4rz 2007 21:44 schrieb Alex Deucher: > Hello, > > I have noticed a strange performance regression and I'm at a loss as > to what's happening. We have a fairly large database (~16 GB). The > original postgres 7.4 was running on a sun v880 with 4 CPUs and 8 GB > of ram running Solaris on local scsi discs. The new server is a sun > Opteron box with 4 cores, 8 GB of ram running postgres 8.1.4 on Linux > (AMD64) on a 4 Gbps FC SAN volume. When we created the new database > it was created from scratch rather than copying over the old one, > however the table structure is almost identical (UTF8 on the new one > vs. C on the old). The problem is queries are ~10x slower on the new > hardware. I read several places that the SAN might be to blame, but > testing with bonnie and dd indicates that the SAN is actually almost > twice as fast as the scsi discs in the old sun server. I've tried > adjusting just about every option in the postgres config file, but > performance remains the same. Any ideas? > 1. Do you use NUMA ctl for locking the db on one node ? 2. do you use bios to interleave memeory ? 3. do you expand cache over mor than one numa node ? > Thanks, > > Alex > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq =2D-=20 ATRSoft GmbH Rosellstrasse 9 D 50354 H=FCrth Deutschland Tel .: +49(0)2233 691324 Gesch=E4ftsf=FChrer Anton Rommerskirchen K=F6ln HRB 44927 STNR 224/5701 - 1010