Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 79AC79FB742 for ; Fri, 2 Mar 2007 12:14:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 84491-04 for ; Fri, 2 Mar 2007 12:14:16 -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 974259FB6C7 for ; Fri, 2 Mar 2007 12:14:16 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id i28so829564wxd for ; Fri, 02 Mar 2007 08:14:16 -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=HCC5rmBY9X+55InDS6PdXdDNIPzHVVTTmkgxZkY94YWudYjSG/O3SAoloRErTZx6B0JPg3O3Dx6H7OwWEK1wKtZ0LjiyTj024V7SAMPLNVSvU8PkmpvZBmnfh4Sj5iY61Kstc9uh9Iq/CAA1QegUsbsZ4mgo1LY/qETwT5usu8s= 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=UX0CxWvaiHD1ccuLBFEWehrSoYQuaOCC/8Gj96eER9WomLsIf9s9Au0sd2WfRKJmWLk6qX8jd7mbQPAWLeXkqSbl9jV9C+8v/9TonsvyDnvrKDNfeW7oC/O2nr9ca+1S44bbv/MTTHKeKkOeuFONzGC5fmR6MmPtXSEoQY0SyqM= Received: by 10.90.51.17 with SMTP id y17mr2941135agy.1172852055908; Fri, 02 Mar 2007 08:14:15 -0800 (PST) Received: by 10.90.116.10 with HTTP; Fri, 2 Mar 2007 08:14:15 -0800 (PST) Message-ID: Date: Fri, 2 Mar 2007 11:14:15 -0500 From: "Alex Deucher" To: "Tom Lane" Subject: Re: strange performance regression between 7.4 and 8.1 Cc: "Jeff Frost" , "Joshua D. Drake" , pgsql-performance@postgresql.org In-Reply-To: <13668.1172851811@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <45E73C90.2080206@commandprompt.com> <13668.1172851811@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/61 X-Sequence-Number: 23466 On 3/2/07, Tom Lane wrote: > "Alex Deucher" writes: > > Anyway, new numbers after the analyze. > > Unfortunately, they are improved, but still not great: > > Why are the index names different between the old and new servers? > Is that just cosmetic, or is 8.2 actually picking a different > (and less suitable) index for the c1 queries? > That's just cosmetic. They are the same. Alex