RE: Diagnosing a massive toast file

Igor Neyman <[email protected]>
Newsgroups gmane.comp.db.postgresql.admin
Message-ID <BN6PR1701MB1890A22C7037904467E7E491DADA0@BN6PR1701MB1890.namprd17.prod.outlook.com> 
From: Wells Oliver [mailto:[email protected]]
Sent: Monday, August 05, 2019 1:43 PM
To: Tom Lane <[email protected]>
Cc: Ron <[email protected]>; [email protected]
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
[email protected]<mailto:[email protected]>


idle_in_transaction_session_timeout GUC is your friend.
Read on it in the docs.

Regards,
Igor Neyman
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.