Re: regression between 8.4.8 and 8.4.2? - Mailing list pgsql-general

From Ben Chobot
Subject Re: regression between 8.4.8 and 8.4.2?
Date
Msg-id 0DA23DFF-FA67-41C8-83EF-D9901AE06141@silentmedia.com
Whole thread Raw
In response to Re: regression between 8.4.8 and 8.4.2?  (Ben Chobot <bench@silentmedia.com>)
List pgsql-general
On Aug 31, 2011, at 11:53 AM, Ben Chobot wrote:

On Aug 31, 2011, at 11:10 AM, Tom Lane wrote:

Ben Chobot <bench@silentmedia.com> writes:
Tom, if there's anything else we can provide that might you out, let me know.

If you could extract a self-contained test case for the bad estimation,
that would be useful.

OK, we'll pull something together. In the meantime, we can confirm that reverting from 8.4.8 to 8.4.3 fixes things.

.... and FWIW 9.0.3 does the right thing as well.

pgsql-general by date:

Previous
From: Ben Chobot
Date:
Subject: Re: regression between 8.4.8 and 8.4.2?
Next
From: "David Johnston"
Date:
Subject: ARRAY_AGG(DISTINCT a ORDER BY b) Error