Re: pg_atributes index space question - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_atributes index space question
Date
Msg-id 6779.1111159769@sss.pgh.pa.us
Whole thread Raw
In response to pg_atributes index space question  (Joe Maldonado <jmaldonado@webehosting.biz>)
List pgsql-general
Joe Maldonado <jmaldonado@webehosting.biz> writes:
> 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

REINDEX is probably the only realistic way to fix that.  It shouldn't
take very long, fortunately, so the exclusive lock shouldn't be an
enormous problem.

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: plpython function problem workaround
Next
From: Tom Lane
Date:
Subject: Re: plpython function problem workaround