"Robert Haas" <robertmhaas@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
