pg_atributes index space question

From: Joe Maldonado <jmaldonado(at)webehosting(dot)biz>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_atributes index space question
Date: 2005-03-18 13:35:22
Message-ID: 423AD91A.1020202@webehosting.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

After a VACUUM FULL I saw that pg_attribute tables indexes haven't
been deleted as reported by a subsequent vacuum analyze. But the pages
corresponding to just the table has been deleted to 196 pages from
about 181557 pages. Are all system tables affected by this ? How can
we reclaim this space without shutting down postmaster ? Is this fixed
in any new release ?

db=# select relpages, reltuples from pg_catalog.pg_class where
relname = 'pg_attribute';
relpages | reltuples
----------+-----------
196 | 9965
(1 row)

db=# vacuum verbose analyze pg_catalog.pg_attribute;
INFO: vacuuming "pg_catalog.pg_attribute"
INFO: index "pg_attribute_relid_attnam_index" now contains 9965 row
versions in 181557 pages
DETAIL: 1518 index row versions were removed.
181263 index pages have been deleted, 20000 are currently reusable.

thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Howie 2005-03-18 14:22:52 Help with transactions
Previous Message Mark Rae 2005-03-18 12:35:04 SMP scaling