I have posted a blog entry about how to get pg_upgrade to generate useful optimizer statistics more quickly once it finishes: http://momjian.us/main/blogs/pgblog/2012.html#March_16_2012 I have also provided scripts that can be used with pg_upgrade 9.1 and earlier, so feel free to try them out. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general