X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5DDB5D1B452 for ; Tue, 2 Dec 2003 20:28:54 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 88959-10 for ; Tue, 2 Dec 2003 16:28:28 -0400 (AST) Received: from live (64-35-136-226.gohighspeed.com [64.35.136.226]) by svr1.postgresql.org (Postfix) with ESMTP id EF7A3D1B470 for ; Tue, 2 Dec 2003 16:28:21 -0400 (AST) Received: from [192.168.254.101] (helo=89glass.com) by live with esmtp (Exim 3.35 #1 (Debian)) id 1ARH89-0004qB-00; Tue, 02 Dec 2003 12:28:21 -0800 Message-ID: <3FCCF61E.90307@89glass.com> Date: Tue, 02 Dec 2003 12:29:18 -0800 From: Jared Carr User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Greg Stark Cc: pgsql-performance@postgresql.org Subject: Re: A question on the query planner References: <3FCBB639.10409@89glass.com> <1070385381.24915.8650.camel@camel> <3FCCD225.8030609@89glass.com> <87d6b79har.fsf@stark.dyndns.tv> <3FCCE48B.10406@89glass.com> <871xrn9e09.fsf@stark.dyndns.tv> In-Reply-To: <871xrn9e09.fsf@stark.dyndns.tv> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/33 X-Sequence-Number: 4893 Greg Stark wrote: >Jared Carr writes: > > > >>Greg Stark wrote: >> >> >> >>>> Merge Cond: ("outer"."?column7?" = "inner"."?column5?") >>>> >>>> >>>> >>>Well it looks like you have something strange going on. What data type is >>>car_id in each table? >>> >>> >>car_id is a varchar(10) in both tables. >> >> > >Well for some reason it's being cast to a text to do the merge. > >What version of postgres is this btw? The analyzes look like 7.4? > > > Yes, this is 7.4.