Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D233764FFD4 for ; Thu, 31 Jul 2008 12:48:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 98028-05 for ; Thu, 31 Jul 2008 12:48:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 25CB364FCCA for ; Thu, 31 Jul 2008 12:48:33 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m6VFmWSO008734; Thu, 31 Jul 2008 11:48:33 -0400 (EDT) To: Marc Fromm cc: "pgsql-admin@postgresql.org" Subject: Re: restore balloons db size In-reply-to: References: Comments: In-reply-to Marc Fromm message dated "Thu, 31 Jul 2008 08:03:44 -0700" Date: Thu, 31 Jul 2008 11:48:32 -0400 Message-ID: <8733.1217519312@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/233 X-Sequence-Number: 29843 Marc Fromm 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