Postgres Pro
Downloads
Home   >   mailing lists

Re: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked - Mailing list pgsql-general

From Tom Lane
Subject Re: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked
Date
Msg-id 1453694.1592419032@sss.pgh.pa.us
Whole thread Raw
In response to RE: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked  ("Jim Hurne" <jhurne@us.ibm.com>)
List pgsql-general
Tree view 
"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 by date:

Previous
From: "Jim Hurne"
Date:
Subject: RE: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked
Next
From: Michel Pelletier
Date:
Subject: Hiding a GUC from SQL