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. - Luke Msg is shrt cuz m on ma treo -----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 DESCLIMIT 1 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