Autovacuum not vacuuming pg_largeobject - Mailing list pgsql-general

From Denis Gasparin
Subject Autovacuum not vacuuming pg_largeobject
Date
Msg-id 46D689DC.5070606@edistar.com
Whole thread Raw
Responses Re: Autovacuum not vacuuming pg_largeobject  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I'm a bit concerned about the autovacuum daemon.

Today I runned a vacuum full during a normal maintainance task and I
noticed that the size of pg_largeobject
decreased from 14GB to 4GB...

Every night we have a procedure that deletes large object no more
referenced using the vacuumlo program.

This program issues delete commands to the pg_largeobject table in order
to erase the rows of the los no more referenced.

Autovacuum is up and running... but now i'm thinking it doesn't examine
system tables such as pg_largeobject...

Am I wrong?

Thank you,
Denis

pgsql-general by date:

Previous
From: "Nitin Verma"
Date:
Subject: Parallel transactions to full vacuum
Next
From: db@zigo.dhs.org
Date:
Subject: Re: lc_collate issue