Hello,m
On 2015-06-26 11:08:30 +0000, matthew.seaman@adestra.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