Search for the connections that are running long for more than a few hours ? or days ? See if any idle in transactions that have now() - state_change, more than a few mins ? or hours ? or days ?
Wells Oliver <wells.oliver@gmail.com> writes: > As a follow up, n_dead_tup from pg_stat_sys_tables for this TOAST table is > 7447444, live tuples, 623982, and tup_del 20823469. vacuum_count is 0.
> Why can't I free those rows up?
Old open transaction somewhere (possibly a prepared transaction?). Or a replication slot that's holding back the xmin horizon due to not keeping up.