Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ayn8z-0003pU-UN for pgsql-hackers@arkaria.postgresql.org; Fri, 06 May 2016 21:18:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ayn8y-0004sO-TZ for pgsql-hackers@arkaria.postgresql.org; Fri, 06 May 2016 21:18:40 +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 1ayn7d-00035v-Lu for pgsql-hackers@postgresql.org; Fri, 06 May 2016 21:17:17 +0000 Received: from www.commandprompt.com ([2604:da00:2:2:5054:ff:fe07:7618] helo=lists.commandprompt.com) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ayn7a-0003mZ-Sj for pgsql-hackers@postgresql.org; Fri, 06 May 2016 21:17:16 +0000 Received: from [192.168.1.60] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id 9ABDE3A9; Fri, 6 May 2016 14:17:13 -0700 (PDT) Received: from c-73-225-27-179.hsd1.wa.comcast.net ([73.225.27.179] helo=[192.168.1.60]) by assp.commandprompt.com with SMTPSA(TLSv1_2 ECDHE-RSA-AES128-GCM-SHA256) (2.4.5); 6 May 2016 14:17:13 -0700 Subject: Re: Reviewing freeze map code To: Andres Freund References: <20160502214818.psk3lmgyihk6gr3k@alap3.anarazel.de> <20160505000840.epatoq6d2e556446@alap3.anarazel.de> <572D0309.4090402@commandprompt.com> <20160506205012.ipuhvctss2ozzs6m@alap3.anarazel.de> <572D0471.3040009@commandprompt.com> <20160506205824.ysst7mk3k26ztok2@alap3.anarazel.de> <572D062E.5030308@agliodbs.com> <572D068F.3050608@commandprompt.com> <20160506210806.f6pnk6ueirjqrlmu@alap3.anarazel.de> Cc: Josh berkus , Robert Haas , Masahiko Sawada , "pgsql-hackers@postgresql.org" From: "Joshua D. Drake" Organization: Command Prompt, Inc. Message-ID: <572D09D9.5080407@commandprompt.com> Date: Fri, 6 May 2016 14:17:13 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.7.2 MIME-Version: 1.0 In-Reply-To: <20160506210806.f6pnk6ueirjqrlmu@alap3.anarazel.de> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Assp-Version: 2.4.5(15162) on assp.commandprompt.com X-Assp-ID: assp.commandprompt.com m1-69433-12842 X-Assp-Session: 7FC1007D4B58 (mail 1) X-Assp-Envelope-From: jd@commandprompt.com X-Assp-Intended-For: pgsql-hackers@postgresql.org X-Assp-Intended-For: sawada.mshk@gmail.com X-Assp-Intended-For: robertmhaas@gmail.com X-Assp-Intended-For: josh@agliodbs.com X-Assp-Intended-For: andres@anarazel.de X-Assp-Original-Subject: Re: [HACKERS] Reviewing freeze map code X-Assp-Client-SSL: yes X-Pg-Spam-Score: -4.0 (----) 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 On 05/06/2016 02:08 PM, Andres Freund wrote: >>> VACUUM THEWHOLEDAMNTHING >>> >> >> I know that would never fly but damn if that wouldn't be an awesome keyword >> for VACUUM. > > It bothers me more than it probably should: Nobdy tests, reviews, > whatever a complex patch with significant data-loss potential. But as > soon somebody dares to mention an option name... That is a fair complaint but let me ask you something: How do I test? Is there a script I can run? Are there specific things I can do to try and break it? What are we looking for exactly? A lot of -hackers seem to forget that although we have 100 -hackers, we have 10000 "consultant/practitioners". Could I read the code and with a weekend of WTF and -hackers questions figure out what is going on, yes but a lot of people couldn't and I don't have the time. You want me (or people like me) to test more? Give us an easy way to do it. Otherwise, we do what we can, which is try and interface on the things that will directly and immediately affect us (like keywords and syntax). Sincerely, JD -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are honest with them. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers