Re: [BUGS] ORDER BY...LIMIT optimization does not work with inherited tables

2008-11-21 Thread Heikki Linnakangas
John Smith wrote: I have just run into this issue myself and I was wondering if it is considered a bug or a missing feature? A missing feature. Is there a plan to address this in an upcoming release? Greg Stark worked on so-called "Ordered Append" patch in spring, which would have solved

Re: [BUGS] ORDER BY...LIMIT optimization does not work with inherited tables

2008-11-21 Thread John Smith
I have just run into this issue myself and I was wondering if it is considered a bug or a missing feature? Is there a plan to address this in an upcoming release? Has anyone found a good work around to the problem in the interim? Thanks! John. On Wed, May 7, 2008 at 4:38 AM, Marshall, Steve <[EMA

[BUGS] ORDER BY...LIMIT optimization does not work with inherited tables

2008-05-07 Thread Marshall, Steve
PostgreSQL 8.3 added a new optimization to avoid sorting in queries that use ORDER BY ... LIMIT. This optimization does not work when the query is issued to a parent table with several children, such as a partitioned table. PostgreSQL version: 8.3.1 Operating System:RedHat Enterprise Li