Re: Diagnosing a massive toast file

Tom Lane <[email protected]>
Newsgroups gmane.comp.db.postgresql.admin
Message-ID <[email protected]> 
Wells Oliver <[email protected]> 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.

			regards, tom lane
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.