Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 27DAE2E004A for ; Thu, 17 Apr 2008 05:15:20 -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 82008-05 for ; Thu, 17 Apr 2008 05:15:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from ptb-relay02.plus.net (ptb-relay02.plus.net [212.159.14.213]) by developer.postgresql.org (Postfix) with ESMTP id C2EE62E002D for ; Thu, 17 Apr 2008 05:15:16 -0300 (ADT) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by ptb-relay02.plus.net with esmtp (Exim) id 1JmPGr-00073g-25; Thu, 17 Apr 2008 09:15:05 +0100 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 7EEC6274063; Thu, 17 Apr 2008 09:15:04 +0100 (BST) Message-ID: <48070708.4060605@archonet.com> Date: Thu, 17 Apr 2008 09:15:04 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.12 (X11/20080213) MIME-Version: 1.0 To: Adrian Moisey 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> In-Reply-To: <4806EE1A.8010400@careerjunction.co.za> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: cd17cf18c62fdd218b03f48614043051 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/226 X-Sequence-Number: 29719 Adrian Moisey wrote: > 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 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). > 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. You are tracking ~ 4.6 million pages and have space to track ~ 15.5 million, so that's fine. You are right up against your limit of relations (tables, indexes etc) being tracked though - 1200. You'll probably want to increase max_fsm_relations - see manual for details (server configuration / free space map). -- Richard Huxton Archonet Ltd