Re: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked
Дата
Msg-id 1453694.1592419032@sss.pgh.pa.us
обсуждение исходный текст
Ответ на RE: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked  ("Jim Hurne" <jhurne@us.ibm.com>)
Список pgsql-general
"Jim Hurne" <jhurne@us.ibm.com> writes:
> On one of the instances that is exhibiting the "disk leak" behavior, the
> VACUUM ANALYZE VERBOSE command doesn't generate any output or complete
> before I loose the connection to the database (presumably because I hit a
> connection read timeout). Is it possible to configure th read timeout for
> psql?

You could fool with your tcp timeout settings:

https://www.postgresql.org/docs/current/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS

            regards, tom lane



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

Предыдущее
От: "Jim Hurne"
Дата:
Сообщение: RE: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked
Следующее
От: Michel Pelletier
Дата:
Сообщение: Hiding a GUC from SQL