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 402B6D1B4B5 for ; Tue, 2 Dec 2003 20:11:40 +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 89757-07 for ; Tue, 2 Dec 2003 16:11:14 -0400 (AST) Received: from smtp.istop.com (dci.doncaster.on.ca [66.11.168.194]) by svr1.postgresql.org (Postfix) with ESMTP id 486D8D1B432 for ; Tue, 2 Dec 2003 16:11:08 -0400 (AST) Received: from stark.dyndns.tv (gsstark.mtl.istop.com [66.11.160.162]) by smtp.istop.com (Postfix) with ESMTP id 3F34937430; Tue, 2 Dec 2003 15:11:03 -0500 (EST) Received: from localhost ([127.0.0.1] helo=stark.dyndns.tv ident=foobar) by stark.dyndns.tv with smtp (Exim 3.36 #1 (Debian)) id 1ARGrP-0005xe-00; Tue, 02 Dec 2003 15:11:03 -0500 To: Jared Carr Cc: Greg Stark , 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> In-Reply-To: <3FCCE48B.10406@89glass.com> From: Greg Stark Organization: The Emacs Conspiracy; member since 1992 Date: 02 Dec 2003 15:11:02 -0500 Message-ID: <871xrn9e09.fsf@stark.dyndns.tv> Lines: 18 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/32 X-Sequence-Number: 4892 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? -- greg