| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: restore balloons db size |
| Date: | 2008-07-31 15:48:32 |
| Message-ID: | 8733.1217519312@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
http://www.postgresql.org/docs/8.3/static/storage-file-layout.html
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rafael Domiciano | 2008-07-31 19:08:31 | Postgres User Can Login without a password |
| Previous Message | Marc Fromm | 2008-07-31 15:03:44 | restore balloons db size |