Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 8BA899FB82B for ; Tue, 6 Mar 2007 11:26:30 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 20125-06-4 for ; Tue, 6 Mar 2007 11:25:44 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.232]) by postgresql.org (Postfix) with ESMTP id 208CC9FB950 for ; Tue, 6 Mar 2007 11:25:32 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id i28so2026848wxd for ; Tue, 06 Mar 2007 07:25:30 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=hiBeoPq3512NMlu+szVL9EQpP5ebqeo6hAEgILlWubzTsrZPIDOh+Uji6i0fsjlX1KKl07B4SLuMR5CqWmyiIv/JMV5wy8AQSHqDV01cDyJLpg2z1XK+DFzAWx75nK0pVQY/LHzL+u5+iJfI3q3ktJmpfPd9tjLOdo++LAEU+18= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=b0bnBuE8PL+ZII/C4Wul5THQ981gt7dxrMCiyPg9gcMzIXxrYn11j6WJZ9IKcnxcIAxWSqh8lkCZHwUFcgVcIjoZRWMvWpDBw6zJ1hV7rxOd8w9o1ba+lGt9n+TjEnJAkX17xnJcG9DhYe07O1nkQeX84blV8jQkF+jc2JzRBm8= Received: by 10.90.31.19 with SMTP id e19mr5791928age.1173194730223; Tue, 06 Mar 2007 07:25:30 -0800 (PST) Received: by 10.90.116.10 with HTTP; Tue, 6 Mar 2007 07:25:30 -0800 (PST) Message-ID: Date: Tue, 6 Mar 2007 10:25:30 -0500 From: "Alex Deucher" To: "Guido Neitzer" Subject: Re: strange performance regression between 7.4 and 8.1 Cc: "PostgreSQL Performance" In-Reply-To: <26FE4DE3-7896-4A8F-B26A-4FCDA1890078@event-s.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <2D7248A6-38DB-4FE2-A570-6476D5985E85@event-s.net> <26FE4DE3-7896-4A8F-B26A-4FCDA1890078@event-s.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/130 X-Sequence-Number: 23535 On 3/5/07, Guido Neitzer wrote: > On 05.03.2007, at 19:56, Alex Deucher wrote: > > > Yes, I started setting that up this afternoon. I'm going to test that > > tomorrow and post the results. > > Good - that may or may not give some insight in the actual > bottleneck. You never know but it seems to be one of the easiest to > find out ... > Well, the SAN appears to be the limiting factor. I set up the DB on the local scsi discs (software RAID 1) and performance is excellent (better than the old server). Thanks for everyone's help. Alex