Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Transaction ID Wraparound in Postgres.
and his python script for doing this: https://github.com/pgexperts/flexible-freeze
Also, note that long running transactions can prevent cleanup of tuples. Look for old xact_start values of non-idle queries in pg_stat_activity (particularly "idle in transaction" connections) and old entries in pg_prepared_xacts.
There are no comments on this comment yet.
and his python script for doing this: https://github.com/pgexperts/flexible-freeze
Also, note that long running transactions can prevent cleanup of tuples. Look for old xact_start values of non-idle queries in pg_stat_activity (particularly "idle in transaction" connections) and old entries in pg_prepared_xacts.