Re: pg_upgrade and statistics

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  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +