On Sat, 2007-10-27 at 17:48 -0400, Luke Lonergan wrote:
> Works great - plans no longer sort, but rather use indices as
> expected. It's in use in Greenplum now.
> It's a simple approach, should easily extend from gpdb to postgres.
> The patch is against gpdb so someone needs to 'port' it.
The part of the patch that didn't work for me was the nrels==1 bit. The
way it currently works there is only ever 0 or 2+ rels. The normal
Postgres code has to cater for the possibility of a non-empty parent
table, which seems to destroy the possibility of using this technique.
I agree its annoying and I have a way of doing this, but that's an 8.4
Anybody think different?
In response to
pgsql-performance by date
|Next:||From: Nimesh Satam||Date: 2007-10-28 15:22:53|
|Subject: Append Cost in query planners|
|Previous:||From: Gregory Stark||Date: 2007-10-28 00:20:26|
|Subject: Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1|