Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ayLdN-0002kW-Ne for pgsql-admin@arkaria.postgresql.org; Thu, 05 May 2016 15:56:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ayLdN-0002k2-AR for pgsql-admin@arkaria.postgresql.org; Thu, 05 May 2016 15:56:13 +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 1ayLdM-0002hk-Cy for pgsql-admin@postgresql.org; Thu, 05 May 2016 15:56:12 +0000 Received: from [92.111.176.162] (helo=astaro-nijm.quipment.nl) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ayLdJ-0000tS-VZ for pgsql-admin@postgresql.org; Thu, 05 May 2016 15:56:11 +0000 Received: from [192.168.150.9] (port=57281 helo=strand.quipment.local) by astaro-nijm.quipment.nl with esmtp (Exim 4.82_1-5b7a7c0-XX) (envelope-from ) id 1ayLdF-0004FP-2B; Thu, 05 May 2016 17:56:05 +0200 Received: from STRAND.quipment.local (192.168.150.9) by Strand.quipment.local (192.168.150.9) with Microsoft SMTP Server (TLS) id 15.0.1130.7; Thu, 5 May 2016 17:56:05 +0200 Received: from STRAND.quipment.local ([::1]) by Strand.quipment.local ([::1]) with mapi id 15.00.1130.005; Thu, 5 May 2016 17:56:05 +0200 From: "Vicky Soni - Quipment India" To: Alvaro Herrera CC: "pgsql-admin@postgresql.org" Subject: Re: Autovacuum of pg_database Thread-Topic: [ADMIN] Autovacuum of pg_database Thread-Index: AQHRpuE9ed7JvOOx002tEvcct1h7Bp+qU+OAgAAEdwCAAAIogIAAIs6Q///fXACAACIBwA== Date: Thu, 5 May 2016 15:56:04 +0000 Message-ID: References: <3732a9f6d3d04295b4389a55de43fa15@Strand.quipment.local> <20160505155126.GA180309@alvherre.pgsql> In-Reply-To: <20160505155126.GA180309@alvherre.pgsql> Accept-Language: en-IN, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [192.168.150.2] Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Host-Lookup-Failed: Reverse DNS lookup failed for 92.111.176.162 (failed) 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 Output of given query. Not sharing db names except temp database. 'datminmxid' 1 1 1 template0 16696 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 Thanks & Regards, Vicky Soni Database Administrator -----Original Message----- From: Alvaro Herrera [mailto:alvherre@2ndquadrant.com]=20 Sent: 05 May 2016 21:21 To: Vicky Soni - Quipment India Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Autovacuum of pg_database Vicky Soni - Quipment India wrote: > Hello, >=20 > I have observed that after upgrading from 9.3 to 9.4 o= n windows, autovacuum keep running again and again. >=20 > In 9.3 this was not true. Any recommendations? Maybe there is a multixact wraparound problem. What 9.3 were you running p= reviously, 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 --=20 =C1lvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin