Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B9614476813 for ; Fri, 17 Jan 2003 10:16:44 -0500 (EST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id CEB5D477361 for ; Fri, 17 Jan 2003 10:15:29 -0500 (EST) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 18ZYDW-0006FL-00 for ; Fri, 17 Jan 2003 10:15:34 -0500 Date: Fri, 17 Jan 2003 10:15:34 -0500 From: Andrew Sullivan To: "pgsql-performance@postgresql.org" Subject: Re: 7.3.1 New install, large queries are slow Message-ID: <20030117101534.A23422@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , "pgsql-performance@postgresql.org" References: <9B1C77393DED0D4B9DAA1AA1742942DA0E4C09@pos_pdc.posportal.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: ; from threshar@torgo.978.org on Fri, Jan 17, 2003 at 09:00:19AM -0500 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/181 X-Sequence-Number: 828 On Fri, Jan 17, 2003 at 09:00:19AM -0500, Jeff wrote: > Perhaps this should go on the TODO - when one side is an int8 and the > other is a literal number assume the number to be int8 instead of int4? Actually, this is a broader problem having to do with type coercion. There are a couple of TODO items which refer to this, it looks to me, but in any case there has been _plenty_ of discussion on -general and -hackers about what's wrong here. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110