Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 72F239FA482 for ; Tue, 30 Oct 2007 02:54:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 77459-08 for ; Tue, 30 Oct 2007 02:54:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 3FCA99FA356 for ; Tue, 30 Oct 2007 02:54:07 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l9U5s2sn016596; Tue, 30 Oct 2007 01:54:02 -0400 (EDT) To: "Luke Lonergan" cc: "Gregory Stark" , "Heikki Linnakangas" , "Anton" , pgsql-performance@postgresql.org Subject: Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 In-reply-to: References: Comments: In-reply-to "Luke Lonergan" message dated "Mon, 29 Oct 2007 22:06:02 -0700" Date: Tue, 30 Oct 2007 01:54:02 -0400 Message-ID: <16595.1193723642@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/351 X-Sequence-Number: 27373 "Luke Lonergan" writes: > Sure - it's here: > http://momjian.us/mhonarc/patches_hold/msg00381.html Luke, this is not a patch, and I'm getting pretty dang tired of seeing you refer to it as one. What this is is a very-selective extract from Greenplum proprietary code. If you'd like us to think it is a patch, you need to offer the source code to all the GP-specific functions that are called in the quoted additions. Hell, the diff is *against* GP-specific code --- it removes calls to functions that we've never seen, eg here: - /* Use constant expr if available. Will be at head of list. */ - if (CdbPathkeyEqualsConstant(pathkey)) This is not a patch, and your statements that it's only a minor porting matter to turn it into one are lie^H^H^Hnonsense. Please lift the skirts higher than the ankle region if you want us to get excited. regards, tom lane