From: Gregory Stark <stark@enterprisedb.com>
To: Mark Kirkwood <markir@paradise.net.nz>
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: Tue, 30 Oct 2007 09:06:21 +0000
Message-ID: <87zly1as4y.fsf@oxford.xeocode.com> (raw)
In-Reply-To: <4726C52E.5020909@paradise.net.nz>
References: <C34C09CA.43C59%llonergan@greenplum.com>
<4726C52E.5020909@paradise.net.nz>
"Mark Kirkwood" <markir@paradise.net.nz> writes:
> Luke Lonergan wrote:
>> Sure - it's here:
>> http://momjian.us/mhonarc/patches_hold/msg00381.html
>
> To clarify - we've fixed this in Greenplum db - the patch as submitted is
> (hopefully) a hint about how to fix it in Postgres, rather than a working
> patch... as its full of non-postgres functions and macros:
Oh, that was the problem with the original patch and I thought Luke had said
that was the problem which was fixed.
> 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...)
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's On-Demand Production Tuning
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: stark@enterprisedb.com, markir@paradise.net.nz, llonergan@greenplum.com, heikki@enterprisedb.com, anton200@gmail.com
Subject: Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
In-Reply-To: <87zly1as4y.fsf@oxford.xeocode.com>
* 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