pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Adrian Moisey <adrian@careerjunction.co.za>
To: Bill Moran <wmoran@collaborativefusion.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: db size
Date: Thu, 17 Apr 2008 08:28:42 +0200
Message-ID: <4806EE1A.8010400@careerjunction.co.za> (raw)
In-Reply-To: <20080415071222.36b2e8eb.wmoran@collaborativefusion.com>
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>

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



view thread (17+ messages)  latest in thread

Message-ID: <4806EE1A.8010400@careerjunction.co.za>
Permalink:  ../4806EE1A.8010400@careerjunction.co.za/
Also on:    postgresql.org/message-id/4806EE1A.8010400@careerjunction.co.za

 · 

reply
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: adrian@careerjunction.co.za, wmoran@collaborativefusion.com
  Subject: Re: db size
  In-Reply-To: <4806EE1A.8010400@careerjunction.co.za>

* 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