Marc Fromm <[EMAIL PROTECTED]> writes: > Does anyone have some insight on why the db size is expanding with each > restore? > If I restore all the postgresql databases from pg_dumpall and use the -c to > drop databases before restoring them the size of the base directory > dramatically increases with each restore (193MB to 355MB to 624MB). If I run > vacuumdb, it only drops by a few MB.
Seems a little odd. Please look closer and find out where the bloat is, exactly. If you're not clear on what's what, see http://www.postgresql.org/docs/8.3/static/storage-file-layout.html regards, tom lane -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
