Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 131012E0063 for ; Thu, 17 Apr 2008 05:43:59 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 20124-03 for ; Thu, 17 Apr 2008 05:43:51 -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 30EAC2E0037 for ; Thu, 17 Apr 2008 05:43:54 -0300 (ADT) Received: from [127.0.0.1] (localhost [127.0.0.1]) by cptwks26.careerjunction.local (Postfix) with ESMTP id 6C32DB7BC8; Thu, 17 Apr 2008 10:43:48 +0200 (SAST) Message-ID: <48070DC3.1040709@careerjunction.co.za> Date: Thu, 17 Apr 2008 10:43:47 +0200 From: Adrian Moisey User-Agent: Thunderbird 2.0.0.12 (X11/20080227) MIME-Version: 1.0 To: Richard Huxton CC: Bill Moran , 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> <4806EE1A.8010400@careerjunction.co.za> <48070708.4060605@archonet.com> In-Reply-To: <48070708.4060605@archonet.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/228 X-Sequence-Number: 29721 Hi >> INFO: "blahxxx": scanned 27 of 27 pages, containing 1272 live rows >> and 0 dead rows; 1272 rows in sample, 1272 estimated total rows > > This is a small table that takes up 27 pages and it scanned all of them. > You have 1272 rows in it and none of them are dead (i.e. deleted/updated > but still taking up space). I had a look through a few other tables...: INFO: "table1": scanned 22988 of 22988 pages, containing 2713446 live rows and 895662 dead rows; 45000 rows in sample, 2713446 estimate d total rows INFO: "table2": scanned 24600 of 24600 pages, containing 270585 live rows and 65524 dead rows; 45000 rows in sample, 270585 estimated total rows Is that dead rows an issue? Should I try clean it out? Will it improve performance ? -- 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