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: (view raw, whole thread or download thread mbox)
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.


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-2017 The PostgreSQL Global Development Group