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
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 |