Re: [GENERAL] Autovacuum and pg_largeobject

2010-07-02 Thread Alvaro Herrera
Excerpts from Norberto Delle's message of vie jul 02 13:43:37 -0400 2010: > As far as I know, It's not being locked. We use it to store digitalized > documents > and it's getting very big. I think the server is being turned off before > it can complete > an vacuum pass. The server is not kept on

Re: [GENERAL] Autovacuum and pg_largeobject

2010-07-02 Thread Norberto Delle
Em 2/7/2010 13:57, Alvaro Herrera escreveu: 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

Re: [GENERAL] Autovacuum and pg_largeobject

2010-07-02 Thread Alvaro Herrera
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

[GENERAL] Autovacuum and pg_largeobject

2010-07-02 Thread Norberto Delle
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