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

From Tom Lane
Subject Re: Diagnosing a massive toast file
Date
Msg-id 30508.1565030152@sss.pgh.pa.us
Whole thread Raw
In response to RE: Diagnosing a massive toast file  (Igor Neyman <ineyman@perceptron.com>)
List pgsql-admin
Igor Neyman <ineyman@perceptron.com> writes:
> From: Wells Oliver [mailto:wells.oliver@gmail.com]
>> Do you guys have any kind of regular monitoring in place to flag users who don't politely close their connections?

> idle_in_transaction_session_timeout GUC is your friend.

Good idea, though it's only been around since 9.6.

Also, if you just want to monitor rather than impose a hard limit,
I imagine you can get Nagios to watch for this.

            regards, tom lane



pgsql-admin by date:

Previous
From: Igor Neyman
Date:
Subject: RE: Diagnosing a massive toast file
Next
From: Azimuddin Mohammed
Date:
Subject: please unscbscribe