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 6D92C9DCA13 for ; Mon, 23 Jan 2006 01:13:42 -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 54723-04 for ; Mon, 23 Jan 2006 01:13:41 -0400 (AST) X-Greylist: delayed 00:09:24.596407 by SQLgrey- Received: from mail.pienetworks.com (unknown [210.9.196.17]) by postgresql.org (Postfix) with ESMTP id B18789DCA08 for ; Mon, 23 Jan 2006 01:13:39 -0400 (AST) Received: by mail.pienetworks.com (Postfix, from userid 521) id 1DBDD4C3991; Mon, 23 Jan 2006 13:13:34 +0800 (WST) Received: from tuppy.pienetworks.com (tuppy.pienetworks.com [192.168.1.72]) by mail.pienetworks.com (Postfix) with ESMTP id 999834C3987 for ; Mon, 23 Jan 2006 13:13:32 +0800 (WST) Subject: [Fwd: autovacuum] From: Enzo Daddario To: pgsql-admin@postgresql.org Content-Type: text/plain Date: Mon, 23 Jan 2006 13:16:59 +0800 Message-Id: <1137993419.28308.57.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 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200601/263 X-Sequence-Number: 20351 Sorry I accidentally pressed 'Send'... -------- Forwarded Message -------- From: Enzo Daddario To: pgsql-admin@postgresql.org Subject: autovacuum Date: Mon, 23 Jan 2006 13:07:21 +0800 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) per day. I currently target these high update tables(with vacuumdb via cron) during quieter periods much more frequently than any other tables in the DB's. I would like to use autovacuum but would also like it to cause little/no impact on DB performance. Any experiences/advise would be appreciated. Thanks in advance. Enzo