Postgres Pro
Downloads
Home   >   mailing lists

Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 - Mailing list pgsql-performance

From Simon Riggs
Subject Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
Date
Msg-id 1193520682.4242.607.camel@ebony.site
Whole thread Raw
In response to Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1  ("Luke Lonergan" <LLonergan@greenplum.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Speed difference between select ... union select ... and select from partitioned_table
Next
From: "Luke Lonergan"
Date:
Subject: Re: partitioned table and ORDER BY indexed_field DESCLIMIT 1