Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b9wiD-00006C-6z for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Jun 2016 15:45:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b9wiC-00032Q-GL for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Jun 2016 15:45:08 +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 1b9wiB-0002zy-OM for pgsql-hackers@postgresql.org; Mon, 06 Jun 2016 15:45:07 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1b9wi9-00041L-GP for pgsql-hackers@postgresql.org; Mon, 06 Jun 2016 15:45:06 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id u56Fj2oV022318; Mon, 6 Jun 2016 11:45:02 -0400 From: Tom Lane To: Robert Haas cc: Andres Freund , Michael Paquier , Masahiko Sawada , "pgsql-hackers@postgresql.org" Subject: Re: Reviewing freeze map code In-reply-to: References: <20160606152808.qnkmjixskxq5vtoo@alap3.anarazel.de> Comments: In-reply-to Robert Haas message dated "Mon, 06 Jun 2016 11:37:25 -0400" Date: Mon, 06 Jun 2016 11:45:02 -0400 Message-ID: <22317.1465227902@sss.pgh.pa.us> X-Pg-Spam-Score: -3.3 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org Robert Haas writes: > On Mon, Jun 6, 2016 at 11:28 AM, Andres Freund wrote: >> Except that we right now don't have any realistic way to figure out >> whether this new feature actually does the right thing. > I just don't see how running VACUUM on the all-frozen pages is going > to help. Yes. I don't see that any of the proposed features would be very useful for answering the question "is my VM incorrect". Maybe they would fix problems, and maybe not, but in any case you couldn't rely on VACUUM to tell you about a problem. (Even if you've got warning messages in there, they might disappear into the postmaster log during an auto-vacuum. Warning messages in VACUUM are not a good debugging technology.) regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers