Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id E6F489FB25B for ; Thu, 18 Jan 2007 17:30:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 18892-05 for ; Thu, 18 Jan 2007 17:30:17 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id E8FAD9FB1D2 for ; Thu, 18 Jan 2007 17:30:19 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l0ILUHXn006363; Thu, 18 Jan 2007 16:30:17 -0500 (EST) To: "Jeremy Haile" cc: "Matthew T. O'Connor" , pgsql-performance@postgresql.org Subject: Re: Autoanalyze settings with zero scale factor In-reply-to: <1169151707.6247.1169971737@webmail.messagingengine.com> References: <1169145474.20103.1169962769@webmail.messagingengine.com> <45AFC86B.9010704@zeut.net> <1169151707.6247.1169971737@webmail.messagingengine.com> Comments: In-reply-to "Jeremy Haile" message dated "Thu, 18 Jan 2007 15:21:47 -0500" Date: Thu, 18 Jan 2007 16:30:17 -0500 Message-ID: <6362.1169155817@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/322 X-Sequence-Number: 22923 "Jeremy Haile" writes: > No tables have been vacuumed or analyzed today. I had thought that this > problem was due to my pg_autovacuum changes, but perhaps not. I > restarted PostgreSQL (in production - yikes) About a minute after being > restarted, the autovac process fired up. > What could get PG in a state where autovac isn't running? Um, are you sure it wasn't? The autovac process is not an always-there thing, it quits after each pass and then the postmaster starts a new one awhile later. regards, tom lane