Postgres Pro
Downloads
Home   >   mailing lists

Re: Diagnosing a massive toast file - Mailing list pgsql-admin

From Wells Oliver
Subject Re: Diagnosing a massive toast file
Date
Msg-id CAOC+FBUmpiQtmwn_WNyE-jCZ57h7OebqgBGtpLYFwqBCdkoSaQ@mail.gmail.com
Whole thread Raw
In response to Re: Diagnosing a massive toast file  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Diagnosing a massive toast file
RE: Diagnosing a massive toast file
List pgsql-admin
Tree view
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@sss.pgh.pa.us> wrote:
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.

                        regards, tom lane


--

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Diagnosing a massive toast file
Next
From: Avinash Kumar
Date:
Subject: Re: Diagnosing a massive toast file