Skip site navigation (1) Skip section navigation (2)

Re: autovacuum questions v2

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: kiruu(at)gmx(dot)de
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: autovacuum questions v2
Date: 2008-11-02 12:42:09
Message-ID: 490DA021.3080308@lelarge.info (view raw or flat)
Thread:
Lists: pgsql-admin
Alexander Strotmann a écrit :
> [...]
> we are running a CRM system with Postgres database (version 8.3). To
> organize handwritten contracts we save them scanned as LOBs. Normally
> they are unlinked in case of deleting them. However we run a cron job
> which does vacuumlo to get save that there is nothing in the nirvana.
> My Question: Does the autovacuum also what vacuumlo does or is there a
> way to specify this in the configuration?
> 

Nope. vacuumlo and lo contrib modules are still needed.


-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

In response to

pgsql-admin by date

Next:From: Daniel PuntonDate: 2008-11-02 23:29:31
Subject: pg_dump's table is empty
Previous:From: Alexander StrotmannDate: 2008-11-02 10:18:26
Subject: autovacuum questions v2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group