Arjun Ranade <ranade@xxxxxxxxxxxxxxxxx> writes: > After dropping the replication slot, VACUUM FULL runs fine now and no > longer reports the "oldest xmin is far in the past" Excellent. Maybe we should think about providing better tools to notice "stuck" replication slots. In the meantime, you probably realize this already, but if global xmin has been stuck for months then you're going to have terrible bloat everywhere. Database-wide VACUUM FULL seems called for. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin