Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id EA86B9FB4ED for ; Fri, 6 Apr 2007 11:25:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 14896-03 for ; Fri, 6 Apr 2007 11:24:55 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.236]) by postgresql.org (Postfix) with ESMTP id 4186A9FB3E8 for ; Fri, 6 Apr 2007 11:25:01 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 50so572113wri for ; Fri, 06 Apr 2007 07:24:59 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=h4PCYp4efV7mC/nwK4eKWIf4lMUmnt+K5bnyOiCL7KrKcCZ/4BftZaMJWED5pslya9bNysjbChiuhh2SB/RFahL01+qMLbbGt3SeaFga22qgEbCgmHV7957df65pC5deMXvjhcACUl4tzKsA7DeZZLmY90IzRZbSDf4BCyLDVsQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=Z0x/xzbsU9DQG3/FphHClIRdoWHzE1XXrgR3c012Kltm/gPfdZ84v0LK5ub6/DZD83wXs1mDE2hX2dTeYHg+NZ30IGkSQ3lCUweKh9av4qPbFzQQ7d9CpVIxbxgo8fI3HwL5FB3tb9InpdqQ46gJZZ9vNOd7fHnLEUszzQ9YigI= Received: by 10.114.158.1 with SMTP id g1mr1247795wae.1175869498953; Fri, 06 Apr 2007 07:24:58 -0700 (PDT) Received: by 10.114.157.12 with HTTP; Fri, 6 Apr 2007 07:24:58 -0700 (PDT) Message-ID: Date: Fri, 6 Apr 2007 08:24:58 -0600 From: "Jonathan Ellis" To: "Tom Lane" Subject: Re: Premature view materialization in 8.2? Cc: pgsql-performance@postgresql.org In-Reply-To: <261.1175840636@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: <28349.1175838196@sss.pgh.pa.us> <261.1175840636@sss.pgh.pa.us> X-Google-Sender-Auth: fd0ffd2c9ec39639 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/163 X-Sequence-Number: 24040 On 4/6/07, Tom Lane wrote: > "Jonathan Ellis" writes: > > On 4/5/07, Tom Lane wrote: > >>> Is this a regression, or a "feature" of 8.2? > >> > >> Hard to say without EXPLAIN ANALYZE output to compare. > > > To my eye they are identical other than the speed but perhaps I am > > missing something. > > Yeah, it sure is the same plan, and 8.2 seems to be a tad faster right > up to the hash join on user_id. Is user_id a textual datatype? I'm > wondering if the 8.2 installation is using a different locale --- the > speed of simple string comparisons can be horrifically worse in some > locales compared to others. user_id is an int; they are both C locale.