Kris Jurka <books@ejurka.com> writes:
> Looking at the differences in statistics before and after the ANALYZE the
> only differences are in correlation. This comes from initdb around line
> 1046...
> "$PGPATH"/postgres $PGSQL_OPT template1 >/dev/null <<EOF
> ANALYZE;
> VACUUM FULL FREEZE;
> EOF
> Could this be done better in the one step VACUUM FULL FREEZE ANALYZE or
> ANALYZING after the VACUUM FULL?
Hm. We can't do it like that, because that would leave the pg_statistic
rows unfrozen. I suppose we could do
VACUUM FULL;
ANALYZE;
VACUUM FREEZE;
regards, tom lane