Re: Diagnosing a massive toast file

Thanks, that was it exactly. PGAdmin session opened for a week. Argh. Gotta
have some conversations with some folks.

Do you guys have any kind of regular monitoring in place to flag users who
don't politely close their connections?

On Mon, Aug 5, 2019 at 10:24 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Wells Oliver <wells(dot)oliver(at)gmail(dot)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.
>
> regards, tom lane
>

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>