Postgres Pro
Downloads
Home   >   mailing lists

Re: Bogus nestloop join estimate, ignores WHERE clause - Mailing list pgsql-hackers

From Marti Raudsepp
Subject Re: Bogus nestloop join estimate, ignores WHERE clause
Date
Msg-id CABRT9RDfSZn++xWfvrpKJ4Du6L1rRs=GGY-O+o=2dwz4uovoeA@mail.gmail.com
Whole thread Raw
In response to Re: Bogus nestloop join estimate, ignores WHERE clause  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Tree view 
On Wed, Aug 31, 2011 at 16:34, Peter Eisentraut <peter_e@gmx.net> wrote:
> On ons, 2011-08-31 at 15:38 +0300, Marti Raudsepp wrote:
>> I'm getting really surprising planner estimates for a query that's
>> joining another table via a varchar field. All of this was tested on
>> PostgreSQL 8.4.8, 9.0.4 and 9.1rc1.
>
> By any chance, did it work better in 8.4.7?

No. Estimates on 8.4.7 are pretty much the same (139820, 139820 and 9455)

(I built and installed 8.4.7 with a clean database)

Regards,
Marti Raudsepp
voicecom.ee

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Bogus nestloop join estimate, ignores WHERE clause
Next
From: Gary Merkel
Date:
Subject: dblink make fails under postgresql 8.4.4 on mac osx 10.4.11