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? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
