Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ayLYt-0002Ve-Uw for pgsql-admin@arkaria.postgresql.org; Thu, 05 May 2016 15:51:36 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ayLYt-0006jq-9u for pgsql-admin@arkaria.postgresql.org; Thu, 05 May 2016 15:51:35 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ayLYs-0006jf-QM for pgsql-admin@postgresql.org; Thu, 05 May 2016 15:51:34 +0000 Received: from out.smtp-auth.no-ip.com ([8.23.224.60]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1ayLYq-0000mZ-1N for pgsql-admin@postgresql.org; Thu, 05 May 2016 15:51:33 +0000 X-No-IP: alvh.no-ip.org@noip-smtp X-Report-Spam-To: abuse@no-ip.com Received: from alvin.alvh.no-ip.org (unknown [216.155.90.98]) (Authenticated sender: alvh.no-ip.org@noip-smtp) by smtp-auth.no-ip.com (Postfix) with ESMTPA id 976D0400CB6; Thu, 5 May 2016 08:51:30 -0700 (PDT) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id 0ADCE438; Thu, 5 May 2016 12:51:26 -0300 (CLST) Date: Thu, 5 May 2016 12:51:26 -0300 From: Alvaro Herrera To: Vicky Soni - Quipment India Cc: "pgsql-admin@postgresql.org" Subject: Re: Autovacuum of pg_database Message-ID: <20160505155126.GA180309@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <3732a9f6d3d04295b4389a55de43fa15@Strand.quipment.local> User-Agent: Mutt/1.5.23 (2014-03-12) X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Vicky Soni - Quipment India wrote: > Hello, > > I have observed that after upgrading from 9.3 to 9.4 on windows, autovacuum keep running again and again. > > In 9.3 this was not true. Any recommendations? Maybe there is a multixact wraparound problem. What 9.3 were you running previously, and what 9.4 did you upgrade to? Can you share the output of pg_controldata? Please paste the output of this query select datname, datminmxid from pg_database -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin