X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CE0DB52824 for ; Thu, 26 May 2005 14:42:05 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 90386-03 for ; Thu, 26 May 2005 17:42:04 +0000 (GMT) Received: from colo.samason.me.uk (unknown [69.55.228.22]) by svr1.postgresql.org (Postfix) with ESMTP id F101F52848 for ; Thu, 26 May 2005 14:42:03 -0300 (ADT) Received: from colo.samason.me.uk (colo [69.55.228.22]) by colo.samason.me.uk (8.12.11/8.12.11) with ESMTP id j4QHg3Ud002834 for ; Thu, 26 May 2005 18:42:03 +0100 (BST) (envelope-from sam@colo.samason.me.uk) Received: (from sam@localhost) by colo.samason.me.uk (8.12.11/8.12.11/Submit) id j4QHg30R002832 for pgsql-performance@postgresql.org; Thu, 26 May 2005 18:42:03 +0100 (BST) (envelope-from sam) Date: Thu, 26 May 2005 18:42:03 +0100 From: Sam Mason To: pgsql-performance@postgresql.org Subject: Re: Optimising queries involving unions Message-ID: <20050526174203.GK15205@colo.samason.me.uk> Mail-Followup-To: Sam Mason , pgsql-performance@postgresql.org References: <20050526152203.GI15205@colo.samason.me.uk> <3339.1117126434@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3339.1117126434@sss.pgh.pa.us> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/397 X-Sequence-Number: 12561 Tom Lane wrote: >It'd be nice to fix this someday, but don't hold your breath ... Thanks for the response! Is it even worth me thinking about trying to figure out how to make the current code do this sort of thing? or is it just not going to happen with the code as it is? Sam