Re: regression between 8.4.8 and 8.4.2?

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: regression between 8.4.8 and 8.4.2?
Date: 2011-08-31 22:49:18
Message-ID: 0DA23DFF-FA67-41C8-83EF-D9901AE06141@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)silentmedia(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-08-31 22:54:37 ARRAY_AGG(DISTINCT a ORDER BY b) Error
Previous Message Marcos Hercules Santos 2011-08-31 22:39:36 function on trigger