uher dslij <codon3@xxxxxxxxx> writes: > The EXPLAINs all pretty much look like my original post. The planner in > 9.2 and above is simply not using bitmap heap scans or bitmap index scans? > What could be the reason for this? I don't see any reason to think this is a planner regression. The rowcount estimates are pretty far off in both versions; so it's just a matter of luck that 9.0 is choosing a better join order than 9.3. I'd try cranking up the statistics targets for the join columns (particularly domain_id) and see if that leads to better estimates. 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
