Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id AB0BF64FD49 for ; Sun, 2 Nov 2008 08:42:19 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 02293-06 for ; Sun, 2 Nov 2008 08:42:19 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sd-2317.dedibox.fr (sd-2317.dedibox.fr [88.191.17.192]) by mail.postgresql.org (Postfix) with ESMTP id 9B42864FD18 for ; Sun, 2 Nov 2008 08:42:16 -0400 (AST) Received: from [192.168.1.10] (ASte-Genev-Bois-153-1-22-97.w83-112.abo.wanadoo.fr [83.112.202.97]) by sd-2317.dedibox.fr (Postfix) with ESMTP id A18CD25D1; Sun, 2 Nov 2008 13:42:13 +0100 (CET) Message-ID: <490DA021.3080308@lelarge.info> Date: Sun, 02 Nov 2008 13:42:09 +0100 From: Guillaume Lelarge User-Agent: Thunderbird 2.0.0.17 (X11/20080925) MIME-Version: 1.0 To: kiruu@gmx.de CC: pgsql-admin@postgresql.org Subject: Re: autovacuum questions v2 References: <490D7E72.90108@gmx.de> In-Reply-To: <490D7E72.90108@gmx.de> Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 8bit X-Archive-Number: 200811/2 X-Sequence-Number: 30656 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