Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id F1CFE9FB81F for ; Thu, 19 Apr 2007 18:00:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 89466-07 for ; Thu, 19 Apr 2007 18:00:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from vms042pub.verizon.net (vms042pub.verizon.net [206.46.252.42]) by postgresql.org (Postfix) with ESMTP id 24FAB9FB5AC for ; Thu, 19 Apr 2007 18:00:13 -0300 (ADT) Received: from new-host.home ([71.166.59.121]) by vms042.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JGR00JN0JNNS799@vms042.mailsrvcs.net> for pgsql-admin@postgresql.org; Thu, 19 Apr 2007 15:59:51 -0500 (CDT) Date: Thu, 19 Apr 2007 16:59:42 -0400 From: Robert Treat Subject: Re: Auto vacuum In-reply-to: <5FB3A3D2-1B25-4DEC-AC42-FB8B5B978E56@indiana.edu> To: pgsql-admin@postgresql.org Cc: Carol Walter , Alvaro Herrera , Tom Lane Message-id: <200704191659.44378.robert@omniti.com> Organization: OmniTI MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7bit Content-disposition: inline References: <20070419145320.GD8402@alvh.no-ip.org> <5FB3A3D2-1B25-4DEC-AC42-FB8B5B978E56@indiana.edu> User-Agent: KMail/1.9.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/201 X-Sequence-Number: 25265 On Thursday 19 April 2007 13:54, Carol Walter wrote: > I certainly appreciate the help you've given. Here's what the code > in this part of postgresql.conf file says. > > autovacuum = on > > autovacuum_naptime = 30 # time between autovacuum runs, in secs > autovacuum_vacuum_threshold = 500 # min # of tuple updates before > # vacuum > autovacuum_analyze_threshold = 250 # min # of tuple updates before > # analyze > autovacuum_vacuum_scale_factor = 0.2 # fraction of rel size before > # vacuum > autovacuum_analyze_scale_factor = 0.1 # fraction of rel size before > # analyze > autovacuum_vacuum_cost_delay = -1 # default vacuum cost delay for > # autovac, -1 means use > # vacuum_cost_delay > #autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for > # autovac, -1 means use > # vacuum_cost_limit > Do you know if you have done a reload of the config files since these were changed? Try doing a select * from pg_settings where name ~ 'autovacuum' to see what your db is currently using. -- Robert Treat Database Architect http://www.omniti.com