Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 1D8B96332E7 for ; Sat, 1 May 2010 20:09:46 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 21902-09 for ; Sat, 1 May 2010 23:09:37 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id E66BE6326E2 for ; Sat, 1 May 2010 20:09:38 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o41N9Z7M011025; Sat, 1 May 2010 19:09:35 -0400 (EDT) To: "Benjamin Krajmalnik" cc: "Kevin Grittner" , pgsql-admin@postgresql.org Subject: Re: Autovacuum stopped running In-reply-to: References: <4BDBF3C90200002500031147@gw.wicourts.gov> Comments: In-reply-to "Benjamin Krajmalnik" message dated "Sat, 01 May 2010 11:15:53 -0600" Date: Sat, 01 May 2010 19:09:35 -0400 Message-ID: <11024.1272755375@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.864 tagged_above=-10 required=5 tests=AWL=0.046, BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/6 X-Sequence-Number: 34479 "Benjamin Krajmalnik" writes: > TO be truthful, I did not check that. > I arrived at the conclusion because although I have 10 autovacuum > threads, none of the tables had been autoanalyzed or autovacuumed in > hours (and due to the nature of the activity they do so every minute). > If I ever see this behavior now I know what to check for :) Thx. We've seen one or two previous reports that suggested that the autovac launcher might have stopped launching workers, but it hasn't been reproducible. Are you using any nonstandard parameters for autovacuum? regards, tom lane