Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b0LzK-00089F-OH for pgsql-hackers@arkaria.postgresql.org; Wed, 11 May 2016 04:43:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b0LzK-0005hj-4V for pgsql-hackers@arkaria.postgresql.org; Wed, 11 May 2016 04:43:10 +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 1b0LzJ-0005hd-Iz for pgsql-hackers@postgresql.org; Wed, 11 May 2016 04:43:09 +0000 Received: from mail-eopbgr700081.outbound.protection.outlook.com ([40.107.70.81] helo=na01-by2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1b0LzB-0003zE-Jh for pgsql-hackers@postgresql.org; Wed, 11 May 2016 04:43:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=BlueTreble.onmicrosoft.com; s=selector1-bluetreble-com; h=From:To:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=DBUu4J+9Jtkwz3RlQhoxTKjaX4PCjeQy0iNE7QZbmV0=; b=LUjdagn3ENNlY3nlObH9sokrPNPJZf00MjkuzwMiPVMhiOahsO9QyYWo9Zu60poGNBWdRrflGRRNmajnqvqDcVGiN4TSyZY9AnUJ5DYHpYJhAr2TGljGuOGS2EjIfiVKPtbxWWyOIi0ZWJ+k9YEo8GMLmFFpZ14AEfVIQ/yUD7c= Authentication-Results: gmail.com; dkim=none (message not signed) header.d=none;gmail.com; dmarc=none action=none header.from=BlueTreble.com; Received: from decina.attlocal.net (108.232.179.70) by SN1PR11MB0687.namprd11.prod.outlook.com (10.163.207.145) with Microsoft SMTP Server (TLS) id 15.1.492.11; Wed, 11 May 2016 04:42:58 +0000 Subject: Re: Reviewing freeze map code To: Peter Geoghegan , Andres Freund References: <20160506212958.wwwc22hfesvj76af@alap3.anarazel.de> <20160506213652.GA288015@alvherre.pgsql> <20160506214943.d44r4glxgw2ff2sg@alap3.anarazel.de> CC: Alvaro Herrera , "Joshua D. Drake" , Josh berkus , Robert Haas , Masahiko Sawada , "pgsql-hackers@postgresql.org" , Jeff Janes From: Jim Nasby Message-ID: <1e78ce70-db1e-e639-f758-dc202f56ab5e@BlueTreble.com> Date: Tue, 10 May 2016 23:42:53 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:45.0) Gecko/20100101 Thunderbird/45.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [108.232.179.70] X-ClientProxiedBy: DM2PR11CA0024.namprd11.prod.outlook.com (10.160.91.34) To SN1PR11MB0687.namprd11.prod.outlook.com (10.163.207.145) X-MS-Office365-Filtering-Correlation-Id: a929f589-7be8-47a0-240a-08d37956baa4 X-Microsoft-Exchange-Diagnostics: 1;SN1PR11MB0687;2:5m2Wz1fJWUFwkkf8blx95G3tIsjun6NpCH3VzK0EXqJwghynz0FHc2sAmXAVhXtimIdCBxmZxW3qbkG3TyL7ns9lBiwuMQ+IbzmHwQLh5iyi/nyM8AQ3TPQH1wkPqJ+pHg0BsqigFKK8SQ3IIfNg3EJU26YVrpRDIyG/rjJEnPyRd+RnbzhCvedWz+OwnFi6;3:ZzQbbaXzahWv3A3HDp5Z+ZpIf9+iHYR2b+QAwsaEKc26g0WztEjvzjfRm9OOibsW0oRHDRXazlwckSdWyA0vVrkbbrCwy3rRdVg5J2kyg8MVIsvHhy1rEAYykSs1NyRv;25:SDxRlg3gzlufveW5DAVenHtm7Uh/pSsJCto0atCf6QAedOlN5y3lOVCIV7YD0EJMKjDD/YeQ8l9KNYEVrDziFd4H/DCzXWO2MuzOiNHX/rEdDtmRpdwxWLnfv1tdFRXmBhtfKxxnuUwLdH7nTUC8rgnL//er/a/E43Uj9LayvasNZycO00lEQnqxLCaoQOAdmOyBhL/WXLmxSOfZlMNCFgi0j3tI246/g6iD3d0HF+91zhs4O1TRBz3nH7e/+oqMvok2QWPwEqILyJx02eHXtc/A4EKWsGDUNxPuOGbrQi39YFmiur/eHWZcwJa1GHscR1cSiygNZ/eWH9zpSInREQzfxNdb10llIJZj/FhGzDPM4p6KhDHPIih44q6yUOgqExNvh900+VxpavZJYxU/duF8sQfcvSZXr8NvtbsK9lxSLWybvE9zgXXr2GFXkJzw X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:SN1PR11MB0687; X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(6040130)(601004)(2401047)(5005006)(8121501046)(10201501046)(3002001)(6041072)(6043046);SRVR:SN1PR11MB0687;BCL:0;PCL:0;RULEID:;SRVR:SN1PR11MB0687; X-Microsoft-Exchange-Diagnostics: 1;SN1PR11MB0687;4:1khMoaZh7cfwRI1Vr/ikLZDeivuwQFWhTos5sY47OWhp+UU2AyrGrWHQ3c7SgegNceaicuk/CSYVG9eoQmVu6mHCLhtoa6MZWZ3sTWQZclB3jkRbCgiv0YzUeZ4dQgjPIHt9UvyriyRP1sBrMR2qHiJI54lP+vQQfPjZhk+OSdPIGsSWyp1W83Zfq/bE54UHlm+6gAa6SWcou+UDgwRhVl3j0sdUuVXyjlQUJKxwIgWv8Pd/yL8gZsCfgzBQ842fbDKHFFgh/hjHMFZR3HOv/QtdCGAix8oaM56h2rzK1GR/JRoBfpLbCczieto94/t9AFJZTOpeLb7x2ol+RU1AkyWwLH9s2SKsh0W4LOTFKF2zlQ8LN5ztAfp3WbrUE44NZRRWJxvCbs289rbcWg0jMJij3Oyn+V/F+Fu7dU1kup0= X-Forefront-PRVS: 0939529DE2 X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(24454002)(377454003)(23676002)(6116002)(3846002)(65956001)(66066001)(586003)(5004730100002)(4326007)(5008740100001)(93886004)(189998001)(36756003)(65806001)(92566002)(50986999)(53416004)(33646002)(54356999)(16601075003)(19580405001)(83506001)(50466002)(5001770100001)(19580395003)(42186005)(86362001)(81166006)(31696002)(15975445007)(2950100001)(47776003)(77096005)(2906002)(31686004)(76176999)(4001350100001)(65826006)(85282002);DIR:OUT;SFP:1101;SCL:1;SRVR:SN1PR11MB0687;H:decina.attlocal.net;FPR:;SPF:None;MLV:sfv;LANG:en; X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtTTjFQUjExTUIwNjg3OzIzOlVYK0ZtVlpLc3hlenJyTnYyWXJvSkRvOFpo?= =?utf-8?B?QWRRNGgzdEdLSFRwNlYwS1dPSGF5WEc1VHR3ZTUxV09yYU5uRWJLVUpTa2N2?= =?utf-8?B?ejF0SVNkVnZ5OThPT1Fuei9ZLytPUmo5RDRyNEx5Z0NjalRPalhCcStZdk1o?= =?utf-8?B?OU1qK2NodXpub09lMEVjZUhrQ256RCtNdzZvUjd6TjExcTFFd1NOaGNZRXUr?= =?utf-8?B?RTZOMkh4N21yNEwweTJpalc4MTY4SjhpM0pyNWkrZUU2SEIyRE9mU0tCOWR4?= =?utf-8?B?Mmc4ZnIzZTRoMmZVdWtDU1VMREUrOTRha1hyc3JQN1k1VUwvNGJ4KzVNVnJL?= =?utf-8?B?S1AyejJGTjZadHFFMDNEeGM4Rm1zL3pwQjI2OTRMMVFSa3BweEFqUW9wQkQ5?= =?utf-8?B?OFcxZHpUYTNJbVpBc2wvdElBbEVDM3ZMaEpFWG9BN2pOMWtJNk96WW1JbFdU?= =?utf-8?B?cGsrUGFhaW9iT1hnWVgzUWFzaCtuSE55S3pXbThHMG5PaUFvc0ppbDFoYzZS?= =?utf-8?B?amEyNHFEdDJqM0hwY0RrSlA1MktaazUwcU1hR3lNYXg4UXlRbi9mdm92dWFL?= =?utf-8?B?TVN3YVFmSnpZS1YvQkNFWnUwYk5tYzRodW9wMjk3VEJhRU9qOUd3enRMejMz?= =?utf-8?B?RngzeXFLWW8xVUxPN25jbjcrNFhEYnloZ3JGRTBtY1JINGNNUjRoblo4RnJR?= =?utf-8?B?NnppdS9IOHBpZ3R3S0ExeVppZldkNFhqT3ZvL1E1ZnVFWEpPYmZ1MGtXUXkz?= =?utf-8?B?ZG9kdTlOT0pDNDA5YVRNaDZzRmFSeEJYVnVKOS9XR1F6QldjckFNR2ZVZ3k0?= =?utf-8?B?QkczZDZYcjBleUpPZis3YVFSL3g3QkZJS3lORzRmQTd5ZWw2T1lxUnZLdDAr?= =?utf-8?B?ZSsrdVNiQWJaZnkyQTMwVXlHK3k3UnRGUlhEVURGYXdaalpzVmFlWjhOWDJk?= =?utf-8?B?cXRBSEdjTHR5NUZRUTJ2WDJOVDkvaUx5RW83UGVLVk9iaHBZTm5VdUR2L0k1?= =?utf-8?B?VDVhbmEzUlNGYVlqWDBCVmVGMS8remxuNHVualFiWHU2R252N0pVdGswWW1M?= =?utf-8?B?ZG55T2ptVVlvaVdZZlQ4UzE0UTU5cEtpajRlaW5yVEtXNjUrd0s4eVNOWDZw?= =?utf-8?B?M0NORzRtL1JyWG8rVHErbW9UUmhEUFNpZTJmTTBvVnpGUUVvOE8rd2NmelFY?= =?utf-8?B?Z2d4S2NLaG95elBtMC9JK01wVCtaQVRZZDlGa3RJMzhSV1lmSkdKb2VzR0sv?= =?utf-8?B?UWpKYjdxbU9zbUJzZGlXSm0wM2VrY1JjbEZZY3Irb2xQdHhaaHJsbjBVaFlK?= =?utf-8?B?UXlVRXJOVTh6eEc2bkRLR1FVZ3VyWWhxVDI4eWJpR1BpcXJmTW9yNE9PUVdn?= =?utf-8?B?ZHIvNEYvVlhiQTFHV3A3WWpHN3ZENFRIalJleE1DMG9jNk5UYUxuaStuK21S?= =?utf-8?B?UWFsRURxT2V6VXVISGJGMVlGanRNQnZzNkZudEV0a0ZnalBXNWJUR1pOSUlj?= =?utf-8?Q?49B3aIDeoND40PBqvWsUqugQ7M20c/y6/b0t3SqZdODP+O?= X-Microsoft-Exchange-Diagnostics: 1;SN1PR11MB0687;5:TgPmUxqK0+x7UY3G02SNywGEDpZwnOkxP3ZTnbWGX2Ve06lfEQfkeJcuvqG+uzlzkvOXGqJJJ/J8GSQfhnkGOb2B2mmqcdqZ4nLKcJq5eq8FXx5Mvg2/JSo2hD36bcCM80U4gPYxLxmcoD06LIvJsA==;24:EumcIlMOD2PqBnzDVlIrE4x0afAI4LiogJnGfeWl7ukp6w0N2Rr21Gijwy70hY+NYe3k15/wiDBV1hEqUnh5kM4+aWpEVCYZ586gOLe7T9w=;7:xylsl4/zpOisBPGhG0DQByIe5WGk29/d+QDGX0p0krj3E/kc51F+G3h+w5vcmKgMBmsRcl1kbeqKuc+e6oudQI08WZgGiXLzUtiNpuSD5HlH28tjqUNdCteO1HzMLJm6g0ZhOgJnoo5h8oAqZeCiAYQqSeHYuGAew9YD+Y2t1aHhvnwMK/4rCbDeYYfzU9oW SpamDiagnosticOutput: 1:23 SpamDiagnosticMetadata: NSPM X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 11 May 2016 04:42:58.6714 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: SN1PR11MB0687 X-Pg-Spam-Score: -1.9 (-) 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 5/6/16 4:55 PM, Peter Geoghegan wrote: > On Fri, May 6, 2016 at 2:49 PM, Andres Freund wrote: >>> Jeff Janes has done astounding work in these matters. (I don't think >>> we credit him enough for that.) >> >> +many. > > Agreed. I'm a huge fan of what Jeff has been able to do in this area. > I often say so. It would be even better if Jeff's approach to testing > was followed as an example by other people, but I wouldn't bet on it > ever happening. It requires real persistence and deep understanding to > do well. It takes deep understanding to *design* the tests, not to write them. There's a lot of folks out there that will never understand enough to design tests meant to expose data corruption but who could easily code someone else's design, especially if we provided tools/ways to tweak a cluster to make testing easier/faster (such as artificially advancing XID/MXID). -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com 855-TREBLE2 (855-873-2532) mobile: 512-569-9461 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers