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

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: John Smith <sodgodofall(at)gmail(dot)com>
Cc: "Marshall, Steve" <smarshall(at)wsi(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: ORDER BY...LIMIT optimization does not work with inherited tables
Date: 2008-11-21 20:10:26
Message-ID: 492715B2.7010903@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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 this, but he didn't get around to finish it for 8.4.
Maybe 8.5...

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Marcus Kempe 2008-11-21 22:18:24 BUG #4544: Wiki user update error
Previous Message John Smith 2008-11-21 18:42:58 Re: ORDER BY...LIMIT optimization does not work with inherited tables