X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4A0BC4758C9 for ; Mon, 28 Apr 2003 07:12:08 -0400 (EDT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id 51B1A474E42 for ; Mon, 28 Apr 2003 07:12:04 -0400 (EDT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 19A6YJ-0003aJ-00 for ; Mon, 28 Apr 2003 07:12:07 -0400 Received: by dba2 (Postfix, from userid 1019) id D8C42CEDF; Mon, 28 Apr 2003 07:12:06 -0400 (EDT) Date: Mon, 28 Apr 2003 07:12:06 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Diferent execution plan for similar query Message-ID: <20030428111206.GA15801@libertyrms.info> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <62257.129.178.88.66.1051527603.squirrel@mail2.fbab.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <62257.129.178.88.66.1051527603.squirrel@mail2.fbab.net> User-Agent: Mutt/1.5.3i X-Spam-Status: No, hits=-34.8 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,REFERENCES, REPLY_WITH_QUOTES,USER_AGENT_MUTT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/230 X-Sequence-Number: 1736 On Mon, Apr 28, 2003 at 01:00:03PM +0200, Magnus Naeslund(w) wrote: > Is this an nontrivial change? > Because if it's trivial it should be done, imho. It's not trivial. If it were, it would have been done already. See the TODO entries about this, and the many discussions about it on -hackers, for why it's not trivial. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110