Identifying diskspace leakage

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Identifying diskspace leakage
Date: 2004-05-14 17:10:05
Message-ID: 200405141110.05616.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I am trying to identify tables with significant diskspace "leakage" due to
in appropriately low max_fsm_pages settings. I can see the results of
VACUUM ANALYZE VERBOSE output counts of tuples and unused tuples, and
understand that (1 - (tuples/unused)) is the amount of diskspace available
to be reclaimed with a VACUUM FULL or dump/reload.

Is there a way to identify the numbers of unused tuples without performing a
VACUUM? Is it stored in a system table anywhere? Other ideas on how to
identify disk bloat short of forcing downtime?

TIA.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff 2004-05-14 17:18:40 Re: dbmirror
Previous Message Ed L. 2004-05-14 17:00:07 Re: dbmirror