X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 26A99D1D2EA for ; Thu, 8 Apr 2004 13:15:04 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 00119-05 for ; Thu, 8 Apr 2004 13:15:02 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id B9461D1D283 for ; Thu, 8 Apr 2004 13:15:00 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i38GEq8h014856; Thu, 8 Apr 2004 12:14:52 -0400 (EDT) To: "Tony and Bryn Reina" Cc: "Douglas Trainor" , pgsql-admin@postgresql.org Subject: Re: Database storage bloat In-reply-to: References: <272e4be7.0404080115.39f1cb36@posting.google.com> <40753A71.3060104@uic.edu> Comments: In-reply-to "Tony and Bryn Reina" message dated "Thu, 08 Apr 2004 15:01:26 +0200" Date: Thu, 08 Apr 2004 12:14:52 -0400 Message-ID: <14855.1081440892@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/156 X-Sequence-Number: 13129 "Tony and Bryn Reina" writes: > There's only about 11 tables in the DB. I included them at the bottom > in case you're interested. What are the actual sizes of the tables? Probably the most useful way you could present that info is "vacuum verbose" output for each table. regards, tom lane