Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id C6C3C650360 for ; Sun, 2 Nov 2008 07:37:54 -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 81748-03-7 for ; Sun, 2 Nov 2008 07:37:54 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by mail.postgresql.org (Postfix) with SMTP id 9B476650B33 for ; Sun, 2 Nov 2008 06:18:29 -0400 (AST) Received: (qmail invoked by alias); 02 Nov 2008 10:18:25 -0000 Received: from p508F335D.dip0.t-ipconnect.de (EHLO [192.168.178.27]) [80.143.51.93] by mail.gmx.net (mp058) with SMTP; 02 Nov 2008 11:18:25 +0100 X-Authenticated: #25259641 X-Provags-ID: V01U2FsdGVkX1+W27c6xImWc7CF8oZuaeqmW2LVlzoiMLHqkHcsrN YRlX8bVIgKTsbA Message-ID: <490D7E72.90108@gmx.de> Date: Sun, 02 Nov 2008 11:18:26 +0100 From: Alexander Strotmann Reply-To: kiruu@gmx.de User-Agent: Thunderbird 2.0.0.17 (Windows/20080914) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: autovacuum questions v2 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-FuHaFi: 0.74 X-Archive-Number: 200811/1 X-Sequence-Number: 30655 Hello community, 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? -- Cheers Alexander Strotmann