Merlin Moncure <mmoncure@xxxxxxxxx> writes: > Problem could also be no statistics (run ANALYZE to test) or some > other configuration problem (like index locale), or a bona fide > regression. I'm wondering about join_collapse_limit in particular --- if that wasn't cranked up in the 9.1 installation, it would be pure luck if you got a good query plan for an example like this. Maybe that and/or other parameter settings didn't get transposed to the 9.2 installation. 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
