Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu> 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
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Rafael Domiciano||Date: 2008-07-31 19:08:31|
|Subject: Postgres User Can Login without a password|
|Previous:||From: Marc Fromm||Date: 2008-07-31 15:03:44|
|Subject: restore balloons db size|