Johan Fredriksson <eskil@xxxxxx> writes: > I am just about to upgrade from PostgreSQL 8.4.20 to 9.2.15, but I'v run > into some huge performance issues. The rowcount estimates from 9.2 seem greatly different from the 8.4 plan. Did you remember to ANALYZE all the tables after migrating? Maybe there were some table-specific statistics targets that you forgot to transfer over? In any case, the 9.2 plan looks like garbage-in-garbage-out to me :-( ... without estimates at least a little closer to reality, the planner is unlikely to do anything very sane. (BTW, I wonder why you are moving only to 9.2 and not something more recent.) 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
