On Sun, Apr 11, 2010 at 3:12 PM, Corin <[email protected]> wrote: > Hi, > > I'm having a query where the planer chooses a very bad plan.
In both instances your number of rows estimated is WAY higher than the actual number of rows returned. Perhaps if you increased default_statistics_target to 100, 200, 500 etc. re-analyzed, and then reun explain analyze again. Also increasing work_mem might encourage the bitmap index scans to occur. -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
