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