Re: Bad Plan for Questionnaire-Type Query - Mailing list pgsql-performance

David,

My first thought would be to increase statistics dramatically on the
filtered columns in hopes of making PG realize there's a lot of rows
there; it's off by 8x.  Correlations stats are an ongoing issue in
PostgreSQL.


--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com