Re: pg_atributes index space question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Maldonado <jmaldonado(at)webehosting(dot)biz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_atributes index space question
Date: 2005-03-18 15:29:29
Message-ID: 6779.1111159769@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joe Maldonado <jmaldonado(at)webehosting(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-03-18 15:33:01 Re: plpython function problem workaround
Previous Message Michael Fuhr 2005-03-18 15:16:57 Re: plpython function problem workaround