RE: Diagnosing a massive toast file

Поиск
Список
Период
Сортировка
От Igor Neyman
Тема RE: Diagnosing a massive toast file
Дата
Msg-id BN6PR1701MB1890A22C7037904467E7E491DADA0@BN6PR1701MB1890.namprd17.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Diagnosing a massive toast file  (Wells Oliver <wells.oliver@gmail.com>)
Ответы Re: Diagnosing a massive toast file  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Дерево обсуждения

From: Wells Oliver [mailto:wells.oliver@gmail.com]
Sent: Monday, August 05, 2019 1:43 PM
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Ron <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org
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@gmail.com

 

 

idle_in_transaction_session_timeout GUC is your friend.

Read on it in the docs.

 

Regards,

Igor Neyman

 

 

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Avinash Kumar
Дата:
Сообщение: Re: Diagnosing a massive toast file
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Diagnosing a massive toast file