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

help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Jeff Frost <jeff@frostconsultingllc.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: vacuum verbose relations reporting
Date: Sun, 31 Aug 2008 12:31:40 -0400
Message-ID: <20080831163140.GA3856@alvh.no-ip.org> (raw)
In-Reply-To: <48BAC44F.6090909@frostconsultingllc.com>
References: <Pine.LNX.4.64.0808261207140.5906@discord.home.frostconsultingllc.com>
	<E1DC2F12-02E8-4D82-9821-B9C7D01657D3@indiana.edu>
	<Pine.LNX.4.64.0808261230460.3638@discord.home.frostconsultingllc.com>
	<11312.1219794535@sss.pgh.pa.us>
	<Pine.LNX.4.64.0808261820360.3638@discord.home.frostconsultingllc.com>
	<20080827013612.GT4920@alvh.no-ip.org>
	<48B4EDF7.9080505@frostconsultingllc.com>
	<48BAC44F.6090909@frostconsultingllc.com>

Jeff Frost wrote:

> I guess this isn't entirely accurate, as the above script returns 35883,
> but vacuum verbose returns:
> 
> INFO:  free space map contains 111435 pages in 10005 relations

Well, what this means is that not every single table has useful free
space ...

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support



view thread (10+ messages)  latest in thread

Message-ID: <20080831163140.GA3856@alvh.no-ip.org>
Permalink:  ../20080831163140.GA3856@alvh.no-ip.org/
Also on:    postgresql.org/message-id/20080831163140.GA3856@alvh.no-ip.org

 · 

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-admin@postgresql.org
  Cc: alvherre@commandprompt.com, jeff@frostconsultingllc.com, tgl@sss.pgh.pa.us
  Subject: Re: vacuum verbose relations reporting
  In-Reply-To: <20080831163140.GA3856@alvh.no-ip.org>

* 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