Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 17E182E0037 for ; Thu, 17 Apr 2008 03:28:58 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 55564-05 for ; Thu, 17 Apr 2008 03:28:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from cptwks26.careerjunction.local (unknown [196.212.105.173]) by developer.postgresql.org (Postfix) with ESMTP id 24EF72E002D for ; Thu, 17 Apr 2008 03:28:50 -0300 (ADT) Received: from [127.0.0.1] (localhost [127.0.0.1]) by cptwks26.careerjunction.local (Postfix) with ESMTP id 9B64FB7BC7; Thu, 17 Apr 2008 08:28:43 +0200 (SAST) Message-ID: <4806EE1A.8010400@careerjunction.co.za> Date: Thu, 17 Apr 2008 08:28:42 +0200 From: Adrian Moisey User-Agent: Thunderbird 2.0.0.12 (X11/20080227) MIME-Version: 1.0 To: Bill Moran CC: pgsql-performance@postgresql.org Subject: Re: db size References: <4802F9E4.3000704@careerjunction.co.za> <48032237.4040604@careerjunction.co.za> <4803276C.2090901@careerjunction.co.za> <48045A32.3010607@careerjunction.co.za> <20080415071222.36b2e8eb.wmoran@collaborativefusion.com> In-Reply-To: <20080415071222.36b2e8eb.wmoran@collaborativefusion.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/224 X-Sequence-Number: 29717 Hi > Running VACUUM VERBOSE will give you a detailed view of space usage of > each individual table. I did that. Not too sure what I'm looking for, can someone tell me what this means: INFO: "blahxxx": scanned 27 of 27 pages, containing 1272 live rows and 0 dead rows; 1272 rows in sample, 1272 estimated total rows INFO: free space map contains 4667977 pages in 1199 relations DETAIL: A total of 4505344 page slots are in use (including overhead). 4505344 page slots are required to track all free space. Current limits are: 15537488 page slots, 1200 relations, using 91172 kB. -- Adrian Moisey Systems Administrator | CareerJunction | Your Future Starts Here. Web: www.careerjunction.co.za | Email: adrian@careerjunction.co.za Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842