Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D464F9FB5AD for ; Thu, 19 Apr 2007 18:25:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 69247-03 for ; Thu, 19 Apr 2007 18:25:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from julesburg.uits.indiana.edu (julesburg.uits.indiana.edu [129.79.1.75]) by postgresql.org (Postfix) with ESMTP id 9EEB99FB4FE for ; Thu, 19 Apr 2007 18:25:36 -0300 (ADT) Received: from mail-relay.iu.edu (logchain.uits.indiana.edu [129.79.1.77]) by julesburg.uits.indiana.edu (8.13.6/8.12.10/IUPO) with ESMTP id l3JLPSp2016993; Thu, 19 Apr 2007 17:25:28 -0400 (EDT) Received: from [129.79.36.69] (walter.slis.indiana.edu [129.79.36.69]) (authenticated bits=0) by mail-relay.iu.edu (8.13.6/8.12.10/IUPO) with ESMTP id l3JLPSeN023505 (version=TLSv1/SSLv3 cipher=AES128-SHA bits=128 verify=NO); Thu, 19 Apr 2007 17:25:29 -0400 (EDT) In-Reply-To: <200704191659.44378.robert@omniti.com> References: <20070419145320.GD8402@alvh.no-ip.org> <5FB3A3D2-1B25-4DEC-AC42-FB8B5B978E56@indiana.edu> <200704191659.44378.robert@omniti.com> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <4F459AFC-5AED-4ACE-9C01-EC23E8F8AB8F@indiana.edu> Cc: pgsql-admin@postgresql.org, Alvaro Herrera , Tom Lane Content-Transfer-Encoding: 7bit From: Carol Walter Subject: Re: Auto vacuum Date: Thu, 19 Apr 2007 17:25:28 -0400 To: Robert Treat X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/187 X-Sequence-Number: 25251 I'm not sure if we've done a reload. I'm in an academic environment and our department is in a state of flux right now. I'm in the process of trying to get up to speed on postgreSQL as fast as I can. Here is the result set from that query. select * from pg_settings where name = 'autovacuum'; name | setting | unit | category | short_desc | extra_desc | context | vartype | source | min_val | max_val ------------+---------+------+------------ +-----------------------------------+- -----------+---------+---------+--------------------+---------+--------- autovacuum | on | | Autovacuum | Starts the autovacuum subprocess. | | sighup | bool | configuration file | | (1 row) Thank you, Carol On Apr 19, 2007, at 4:59 PM, Robert Treat wrote: > 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