On Wed, Oct 24, 2012 at 10:06 AM, Merlin Moncure <mmonc...@gmail.com> wrote: > I was chasing down a query that ran fine in 8.1 but had an near > infinite runtime in 9.2. It turned out to be from a bad filter > estimate that is surprisingly simple to reproduce:
Testing some more it turns out that this isn't really a bug -- it's just a general property of expression based filters: the planner assumes they are very selective when in this case they are not. merlin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
