Re: Diagnosing a massive toast file
Tom Lane <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <[email protected]> |
Igor Neyman <[email protected]> writes: > From: Wells Oliver [mailto:[email protected]] >> 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