"Robert Haas" <robertmh...@gmail.com> writes: > While looking at a complex query that is being poorly planned by > PostgreSQL 8.2.9, I discovered that any non-trivial CASE...WHEN > expression seems to produce a selectivity estimate of 0.005.
If you have an idea for a non-silly estimate, feel free to enlighten us... regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance