Re: Autovacuum and pg_largeobject
От | Alvaro Herrera |
---|---|
Тема | Re: Autovacuum and pg_largeobject |
Дата | |
Msg-id | 1278089733-sup-1860@alvh.no-ip.org обсуждение исходный текст |
Ответ на | Autovacuum and pg_largeobject (Norberto Delle <betodelle@gmail.com>) |
Ответы |
Re: Autovacuum and pg_largeobject
|
Список | pgsql-general |
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?
В списке pgsql-general по дате отправления: