On Tue, Mar 13, 2012 at 03:29:22PM -0500, Kevin Grittner wrote: > I went even lower than you suggested: > > set default_statistics_target = 4; > > And it was much faster, but still more time than the pg_upgrade run > itself: > > cir=# analyze; > ANALYZE > Time: 474319.826 ms > > A little under 8 minutes.
What is the target=10 duration? I think 10 is as low as we can acceptably recommend. Should we recommend they run vacuumdb twice, once with default_statistics_target = 4, and another with the default? -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
