From: Tom Lane <tgl@sss.pgh.pa.us>
To: Marc Fromm <Marc.Fromm@wwu.edu>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: restore balloons db size
Date: Thu, 31 Jul 2008 11:48:32 -0400
Message-ID: <8733.1217519312@sss.pgh.pa.us> (raw)
In-Reply-To: <B0D7C0A3F35FE144A70312D086CBCA9B0CF982A5@ExchMailbox2.univ.dir.wwu.edu>
References: <B0D7C0A3F35FE144A70312D086CBCA9B0CF982A5@ExchMailbox2.univ.dir.wwu.edu>
Marc Fromm <Marc.Fromm@wwu.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, Marc.Fromm@wwu.edu
Subject: Re: restore balloons db size
In-Reply-To: <8733.1217519312@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox