From: Mark Kirkwood <markir@paradise.net.nz>
To: Gregory Stark <stark@enterprisedb.com>
Cc: Luke Lonergan <llonergan@greenplum.com>
Cc: Heikki Linnakangas <heikki@enterprisedb.com>
Cc: Anton <anton200@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
Date: Mon, 05 Nov 2007 18:49:26 +1300
Message-ID: <472EAEE6.2090000@paradise.net.nz> (raw)
In-Reply-To: <87zly1as4y.fsf@oxford.xeocode.com>
References: <C34C09CA.43C59%llonergan@greenplum.com>
<4726C52E.5020909@paradise.net.nz>
<87zly1as4y.fsf@oxford.xeocode.com>
Gregory Stark wrote:
> cdbpathlocus_pull_above_projection
>
>
> In particular this is the function I was hoping to see. Anyways as Tom pointed
> out previously there's precedent in Postgres as well for subqueries so I'm
> sure I'll be able to do it.
>
> (But I'm still not entirely convinced putting the append member vars into the
> eclasses would be wrong btw...)
>
>
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)
The next step would be to update to to HEAD. That would hopefully
provide some useful material for others working on this.
Thoughts suggestions?
regards
Mark
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: markir@paradise.net.nz, stark@enterprisedb.com, llonergan@greenplum.com, heikki@enterprisedb.com, anton200@gmail.com
Subject: Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
In-Reply-To: <472EAEE6.2090000@paradise.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox