On Wed, Aug 31, 2011 at 16:34, Peter Eisentraut <pete...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers