X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A4FF19DC86F for ; Mon, 23 Jan 2006 01:33:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60106-03 for ; Mon, 23 Jan 2006 01:33:31 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.pienetworks.com (unknown [210.9.196.17]) by postgresql.org (Postfix) with ESMTP id 268459DC805 for ; Mon, 23 Jan 2006 01:33:30 -0400 (AST) Received: by mail.pienetworks.com (Postfix, from userid 521) id E1DF04BBFEB; Mon, 23 Jan 2006 13:03:59 +0800 (WST) Received: from tuppy.pienetworks.com (tuppy.pienetworks.com [192.168.1.72]) by mail.pienetworks.com (Postfix) with ESMTP id 25D124BC29E for ; Mon, 23 Jan 2006 13:03:55 +0800 (WST) Subject: autovacuum From: Enzo Daddario To: pgsql-admin@postgresql.org Content-Type: text/plain Date: Mon, 23 Jan 2006 13:07:21 +0800 Message-Id: <1137992841.28304.48.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200601/264 X-Sequence-Number: 20352 Hi All, I am concerned with the impact autovacuum of table(s) would have on regular DB activity. With our current DB's the majority of tables have either a low number of updates or a large number of inserts (which I believe should not be a problem), however, a small number of tables have an extremely high number of updates (up to 150 000)