Re: [PERFORM] partitioned table and ORDER BY indexed_field DESCLIMIT 1

2007-10-28 Thread Simon Riggs
On Sun, 2007-10-28 at 12:53 -0400, Tom Lane wrote: > Simon Riggs <[EMAIL PROTECTED]> 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

Re: [PERFORM] partitioned table and ORDER BY indexed_field DESCLIMIT 1

2007-10-28 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> 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. regards, tom lane ---(end of broadcast

Re: [PERFORM] partitioned table and ORDER BY indexed_field DESCLIMIT 1

2007-10-28 Thread Simon Riggs
On Sat, 2007-10-27 at 17:48 -0400, Luke Lonergan wrote: > Works great - plans no longer sort, but rather use indices as > expected. It's in use in Greenplum now. > > It's a simple approach, should easily extend from gpdb to postgres. > The patch is against gpdb so someone needs to 'port' it. The

Re: [PERFORM] partitioned table and ORDER BY indexed_field DESCLIMIT 1

2007-10-27 Thread Luke Lonergan
Original Message- From: Simon Riggs [mailto:[EMAIL PROTECTED] Sent: Saturday, October 27, 2007 05:34 PM Eastern Standard Time To: Luke Lonergan Cc: Heikki Linnakangas; Anton; pgsql-performance@postgresql.org Subject: Re: [PERFORM] partitioned table and ORDER BY indexed_field