Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1

From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: "Mark Kirkwood" <markir(at)paradise(dot)net(dot)nz>
Cc: "Gregory Stark" <stark(at)enterprisedb(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-10-31 14:16:13
Message-ID: C34DDC3D.43F60%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

BTW - Mark has volunteered to work a Postgres patch together. Thanks Mark!

- Luke

On 10/29/07 10:46 PM, "Mark Kirkwood" <markir(at)paradise(dot)net(dot)nz> wrote:

> 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:
>
> CdbPathLocus_MakeHashed
> cdbpathlocus_pull_above_projection
> cdbpullup_findPathKeyItemInTargetList
> cdbpullup_makeVar
> cdbpullup_expr
>
> Cheers
>
> Mark

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pablo Alcaraz 2007-10-31 15:27:42 Re: tables with 300+ partitions
Previous Message cluster 2007-10-31 09:39:24 Re: Two fast queries get slow when combined