On Sun, Apr 11, 2010 at 3:12 PM, Corin <wakathane@xxxxxxxxx> 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 (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
