Postgres Pro
Downloads
Home   >   mailing lists

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

From Simon Riggs
Subject Re: partitioned table and ORDER BY indexed_field DESCLIMIT 1
Date
Msg-id 1193592444.4242.711.camel@ebony.site
Whole thread Raw
In response to Re: partitioned table and ORDER BY indexed_field DESCLIMIT 1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
On Sun, 2007-10-28 at 12:53 -0400, Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.com> writes:
> > I agree its annoying and I have a way of doing this, but that's an 8.4
> > thing now.
>
> It was an 8.4 thing quite some time ago, since no working patch was ever
> submitted.

Sorry, I meant that the problem itself is annoying, not anything to do
with patches. I'm very happy with all that we've done.

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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: partitioned table and ORDER BY indexed_field DESCLIMIT 1
Next
From: Heikki Linnakangas
Date:
Subject: Re: Append Cost in query planners