Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Mark Kirkwood" <markir(at)paradise(dot)net(dot)nz>
Cc: "Luke Lonergan" <llonergan(at)greenplum(dot)com>, "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, "Anton" <anton200(at)gmail(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
Date: 2007-11-05 12:12:27
Message-ID: 87r6j46gd0.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Mark Kirkwood" <markir(at)paradise(dot)net(dot)nz> 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!

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Claus Guttesen 2007-11-05 13:19:18 hp ciss on freebsd
Previous Message Mark Kirkwood 2007-11-05 05:49:26 Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1