Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ala3Q-0004TI-9U for pgsql-bugs@arkaria.postgresql.org; Thu, 31 Mar 2016 10:42:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ala3P-0006P5-SC for pgsql-bugs@arkaria.postgresql.org; Thu, 31 Mar 2016 10:42:19 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ala2m-0004zy-6X for pgsql-bugs@postgresql.org; Thu, 31 Mar 2016 10:41:40 +0000 Received: from mail.anarazel.de ([217.115.131.40]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ala2j-0001hL-LU for pgsql-bugs@postgresql.org; Thu, 31 Mar 2016 10:41:39 +0000 Received: by mail.anarazel.de (Postfix, from userid 108) id 50A47580003; Thu, 31 Mar 2016 12:41:37 +0200 (CEST) X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on mail X-Spam-Level: X-Spam-Status: No, score=-4.4 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00 autolearn=ham version=3.2.5 Received: from anarazel.de (pD9F6A973.dip0.t-ipconnect.de [217.246.169.115]) (Authenticated sender: andres@anarazel.de) by mail.anarazel.de (Postfix) with ESMTPSA id 4EA1D580001; Thu, 31 Mar 2016 12:41:30 +0200 (CEST) Received: by anarazel.de (Postfix, from userid 1000) id D1666102E6E; Thu, 31 Mar 2016 12:41:29 +0200 (CEST) Date: Thu, 31 Mar 2016 12:41:29 +0200 From: Andres Freund To: andrew@tao11.riddles.org.uk Cc: pgsql-bugs@postgresql.org Subject: Re: BUG #14057: vacuum setting reltuples=0 for tables with >0 tuples Message-ID: <20160331104129.GG23562@awork2.anarazel.de> References: <20160331103739.8956.94469@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20160331103739.8956.94469@wrigleys.postgresql.org> X-Pg-Spam-Score: -5.2 (-----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org Hi Andrew, On 2016-03-31 10:37:39 +0000, andrew@tao11.riddles.org.uk wrote: > It looks like fixing this requires breaking scanned_pages out into at least > two separate counters, since we currently use it to track both whether we > can update stats, and whether we can update relfrozenxid. Are you planning to submit a fix? - Andres -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs