RE: Diagnosing a massive toast file

[Igor Neyman <ineyman@xxxxxxxxxxxxxx>]

From: Wells Oliver [mailto:wells.oliver@xxxxxxxxx]
Sent: Monday, August 05, 2019 1:43 PM
To: Tom Lane <tgl@xxxxxxxxxxxxx>
Cc: Ron <ronljohnsonjr@xxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: 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?

--

Wells Oliver
wells.oliver@xxxxxxxxx

 

 

idle_in_transaction_session_timeout GUC is your friend.

Read on it in the docs.

 

Regards,

Igor Neyman