VACUUM and performance after pg_dumpall

Thomas F.O'Connell <tfo@monsterlabs.com>

From: "Thomas F. O'Connell" <tfo@monsterlabs.com>
To: pgsql-general@postgresql.org
Date: 2001-12-05T22:19:50Z
Lists: pgsql-general
what is it about pg_dumpall that necessitates an immediate VACUUM to 
restore performance?

in upgrading recently from a pre-7.1 release to a 7.1.3 release for a 
fairly sizeable database, i noticed a severe decrease in performance 
that seemed to be related only to the new version of postgres that was 
running. everything else, including DBI, DBD::Pg, etc., remained the same.

i had done a pg_dumpall to preserve the data.

after a VACUUM, performance returned to within acceptable limits.

does pg_dumpall and the subsequent restoration of data create a bunch of 
proverbial dust that needs to be vacuumed?

-tfo