From: Richard Huxton <dev@archonet.com>
To: Adrian Moisey <adrian@careerjunction.co.za>
Cc: Bill Moran <wmoran@collaborativefusion.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: db size
Date: Thu, 17 Apr 2008 09:15:04 +0100
Message-ID: <48070708.4060605@archonet.com> (raw)
In-Reply-To: <4806EE1A.8010400@careerjunction.co.za>
References: <4802F9E4.3000704@careerjunction.co.za>
<op.t9lf4tvrcigqcu@apollo13.peufeu.com>
<48032237.4040604@careerjunction.co.za>
<op.t9lgusticigqcu@apollo13.peufeu.com>
<4803276C.2090901@careerjunction.co.za>
<op.t9lh5em8cigqcu@apollo13.peufeu.com>
<48045A32.3010607@careerjunction.co.za>
<20080415071222.36b2e8eb.wmoran@collaborativefusion.com>
<4806EE1A.8010400@careerjunction.co.za>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, adrian@careerjunction.co.za, wmoran@collaborativefusion.com
Subject: Re: db size
In-Reply-To: <48070708.4060605@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox