Re: can't reindex a couple of tables

Brendan Duddridge <brendan@clickspace.com> writes:
> They both have a click_count column that we update with "update
> attribute set click_count = click_count + 1;" and the same for the
> attribute_value table. Postgres is getting hung up on any transaction
> that attempts to update the click_count. I've vacuum analyzed both
> tables and that worked fine. Now I tried to reindex them and Postgres
> is just locking up and never finishing. I had to cancel the reindex.

I'd wonder about some open transaction with a weak lock on these
tables.  REINDEX needs exclusive lock, vacuum doesn't.
Look in pg_locks ...

            regards, tom lane