Re: BUG #13472: VACUUM ANALYZE hangs on certain tables

Hello,m

On 2015-06-26 11:08:30 +0000, matthew(dot)seaman(at)adestra(dot)com wrote:
> We have two tables which we have not been able to vacuum sucessfully on one
> of our database servers. The vacuum process just hangs almost
> instantaneously after issuing the 'VACUUM ANALYZE' command.

Hm. Is there a chance that your application uses cursors?

Could you send the output of:
SELECT oid::regclass, txid_current(), relfrozenxid, age(relfrozenxid)
FROM pg_class
WHERE oid = 'your relation'::regclass;

My theory is that there's a page that needs to be frozen, but a pin on
the page exists, preventing the cleanup lock from being acquired. Or
rather delaying it long enough that little progress is made.

Greetings,

Andres Freund