Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XUo5I-0001OQ-EQ for pgsql-sql@arkaria.postgresql.org; Fri, 19 Sep 2014 02:38:08 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XUo5H-0000A1-Kc for pgsql-sql@arkaria.postgresql.org; Fri, 19 Sep 2014 02:38:07 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XUo5E-00009C-D1; Fri, 19 Sep 2014 02:38:04 +0000 Received: from smtprelay0174.b.hostedemail.com ([64.98.42.174] helo=smtprelay.b.hostedemail.com) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XUo59-0003PS-U5; Fri, 19 Sep 2014 02:38:02 +0000 Received: from filter.hostedemail.com (b-bigip1 [10.5.19.254]) by smtprelay04.b.hostedemail.com (Postfix) with ESMTP id B5E937B625; Fri, 19 Sep 2014 02:37:58 +0000 (UTC) X-Session-Marker: 616C76686572726540616C76682E6E6F2D69702E6F7267 X-Spam-Summary: 50, 0, 0, , d41d8cd98f00b204, alvherre@alvh.no-ip.org, :::::::::, RULES_HIT:41:355:379:599:800:960:967:973:988:989:1260:1277:1311:1312:1313:1314:1345:1359:1431:1437:1515:1516:1518:1519:1534:1539:1593:1594:1595:1596:1711:1714:1730:1747:1777:1792:2393:2525:2553:2560:2563:2682:2685:2828:2859:2933:2937:2939:2942:2945:2947:2951:2954:3022:3138:3139:3140:3141:3142:3350:3740:3865:3866:3868:3870:3873:3934:3936:3938:3941:3944:3947:3950:3953:3956:3959:4250:4321:4605:4659:5007:6117:6261:9025:9121:10004:10400:10848:11232:11256:11257:11658:11914:12219:12296:12517:12519:12555:13069:13311:13357:13894:13895:21080, 0, RBL:none, CacheIP:none, Bayesian:0.5, 0.5, 0.5, Netcheck:none, DomainCache:0, MSF:not bulk, SPF:fn, MSBL:0, DNSBL:none, Custom_rules:0:0:0 X-HE-Tag: man65_2872b1b75f639 X-Filterd-Recvd-Size: 2159 Received: from eldon.alvh.no-ip.org (pc-65-79-161-190.cm.vtr.net [190.161.79.65]) (Authenticated sender: alvherre@alvh.no-ip.org) by omf03.b.hostedemail.com (Postfix) with ESMTPA; Fri, 19 Sep 2014 02:37:57 +0000 (UTC) Received: by eldon.alvh.no-ip.org (Postfix, from userid 1000) id D56F31FCB; Thu, 18 Sep 2014 23:37:55 -0300 (CLST) Date: Thu, 18 Sep 2014 23:37:55 -0300 From: Alvaro Herrera To: Dev Kumkar Cc: Andres Freund , Adrian Klaver , "pgsql-general@postgresql.org" , pgsql-sql@postgresql.org Subject: Re: [GENERAL] pg_multixact issues Message-ID: <20140919023755.GS4701@eldon.alvh.no-ip.org> References: <54198AEB.2070508@aklaver.com> <5419F908.2080303@aklaver.com> <20140918103338.GF17265@alap3.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org Dev Kumkar wrote: > On Thu, Sep 18, 2014 at 4:03 PM, Andres Freund > wrote: > > Can you show pg_controldata output and the output of 'SELECT oid, > > datname, relfrozenxid, age(relfrozenxid), relminmxid FROM pg_database;'? > > > > Here are the details: > oid datname datfrozenxid age(datfrozenxid) datminmxid > 16384 myDB 1673 10872259 1 Can you paste the pg_controldata output please? Also, what files are there in pg_multixact/offsets/ ? -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql