Excerpts from Norberto Delle's message of vie jul 02 08:10:44 -0400 2010:
> Hi all
>
> I would like to know if the large object table pg_largeobject is
> routinely checked by the autovacuum daemon.
> I ask about this because I have a database in wich the pg_largeobject
> table is being forcibly vacuumed because it's relfrozenxid is now
> greater than autovacuum_freeze_max_age, and it's killing the server
> performance. PostgreSQL version is 8.2.14.
It should, as it should vacuum any other table. Perhaps all the routine
autovacuums were killed because of locking issues. I admit I haven't
investigated the locking behavior of pg_largeobject in particular.
Would it be locked more frequently than other system catalogs?