Brendan Duddridge <brendan@xxxxxxxxxxxxxx> 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
