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