Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0C6BA9F971F for ; Mon, 5 Nov 2007 08:12:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 48937-05 for ; Mon, 5 Nov 2007 08:12:27 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from oxford.xeocode.com (unknown [62.232.55.118]) by postgresql.org (Postfix) with ESMTP id 919039F958B for ; Mon, 5 Nov 2007 08:12:33 -0400 (AST) Received: from localhost ([127.0.0.1] helo=oxford.xeocode.com) by oxford.xeocode.com with esmtp (Exim 4.67) (envelope-from ) id 1Ip0od-00018g-Nx; Mon, 05 Nov 2007 12:12:27 +0000 To: "Mark Kirkwood" Cc: "Luke Lonergan" , "Heikki Linnakangas" , "Anton" , Subject: Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 In-Reply-To: <472EAEE6.2090000@paradise.net.nz> (Mark Kirkwood's message of "Mon\, 05 Nov 2007 18\:49\:26 +1300") User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX" 46444) References: <4726C52E.5020909@paradise.net.nz> <87zly1as4y.fsf@oxford.xeocode.com> <472EAEE6.2090000@paradise.net.nz> From: Gregory Stark Organization: EnterpriseDB Date: Mon, 05 Nov 2007 12:12:27 +0000 Message-ID: <87r6j46gd0.fsf@oxford.xeocode.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/55 X-Sequence-Number: 27470 "Mark Kirkwood" writes: > I spent today looking at getting this patch into a self contained state. > Working against HEAD I'm getting bogged down in the PathKeyItem to > PathKey/EquivalenceClass/EquivalenceMember(s) change. So I figured I'd divide > and conquer to some extent, and initially provide a patch: > > - against 8.2.(5) > - self contained (i.e no mystery functions) That would be helpful for me. It would include the bits I'm looking for. > The next step would be to update to to HEAD. That would hopefully provide some > useful material for others working on this. If that's not too much work then that would be great but if it's a lot of work then it may not be worth it if I'm planning to only take certain bits. On the other hand if it's good then we might just want to take it wholesale and then add to it. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training!