Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Luke Lonergan <LLonergan(at)greenplum(dot)com>
Cc: 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-27 21:31:22
Message-ID: 1193520682.4242.607.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sat, 2007-10-27 at 15:12 -0400, Luke Lonergan wrote:
> And I repeat - 'we fixed that and submitted a patch' - you can find it
> in the unapplied patches queue.

I got the impression it was a suggestion rather than a tested patch,
forgive me if that was wrong.

Did the patch work? Do you have timings/different plan?

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Luke Lonergan 2007-10-27 21:48:16 Re: partitioned table and ORDER BY indexed_field DESCLIMIT 1
Previous Message Simon Riggs 2007-10-27 21:26:49 Re: Speed difference between select ... union select ... and select from partitioned_table