Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Z4kAj-0006iw-Ta for pgsql-hackers@arkaria.postgresql.org; Tue, 16 Jun 2015 06:16:34 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Z4kAj-0008DJ-6F for pgsql-hackers@arkaria.postgresql.org; Tue, 16 Jun 2015 06:16:33 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Z4kAh-0008Cx-Fs for pgsql-hackers@postgresql.org; Tue, 16 Jun 2015 06:16:31 +0000 Received: from mail-bn1bon0092.outbound.protection.outlook.com ([157.56.111.92] helo=na01-bn1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1Z4kAc-0005y8-TY for pgsql-hackers@postgresql.org; Tue, 16 Jun 2015 06:16:30 +0000 Received: from BLUPR11MB0675.namprd11.prod.outlook.com (10.163.216.145) by BLUPR11MB0547.namprd11.prod.outlook.com (10.163.125.142) with Microsoft SMTP Server (TLS) id 15.1.190.14; Tue, 16 Jun 2015 06:16:24 +0000 Authentication-Results: postgresql.org; dkim=none (message not signed) header.d=none; Received: from decina.local (173.243.42.138) by BLUPR11MB0675.namprd11.prod.outlook.com (10.163.216.145) with Microsoft SMTP Server (TLS) id 15.1.190.14; Tue, 16 Jun 2015 06:16:21 +0000 Message-ID: <557F6D32.8080508@BlueTreble.com> Date: Mon, 15 Jun 2015 19:26:26 -0500 From: Jim Nasby User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:31.0) Gecko/20100101 Thunderbird/31.4.0 MIME-Version: 1.0 To: Alvaro Herrera , Josh Berkus CC: Subject: Re: Need Multixact Freezing Docs References: <534DA3D1.2010000@agliodbs.com> <534DB22A.2040909@agliodbs.com> <20140416133233.GL5822@eldon.alvh.no-ip.org> <534EC69B.9010107@agliodbs.com> <20150614145018.GE133018@postgresql.org> In-Reply-To: <20150614145018.GE133018@postgresql.org> Content-Type: text/plain; charset="windows-1252"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [173.243.42.138] X-ClientProxiedBy: CY1PR0201CA0031.namprd02.prod.outlook.com (25.163.30.169) To BLUPR11MB0675.namprd11.prod.outlook.com (25.163.216.145) X-Microsoft-Exchange-Diagnostics: 1; BLUPR11MB0675; 2:46PojGWNAX3nXK8K1/QbQk15zbvWJTWN1RU91LuVHLQGp/pKsNUPC+MsYB86X666; 2:OVSN/yN3o9O+VlciD7mXxK4Jp4SluJ/P+EeNb2vHQGwnmNjbvnP04u+ahEr8Ue4mYls7fXIqBjWEfTyssZnYHQjgsX2CI3dWETVFO/bYsTx1N9B235NK09n9jeRkdEXZHO6yE1ZiaLPuclnZXs0Gqw==; 3:al9y3oxjPa7TJ8vjmhfsIdsYxwxzsVnT7QEdEBVOq4PepFTsV4i3gtjiLQxXUt0YenI351IXihwCKjW7LoK09ha1rLHr+Vmb+rNQxQ+AcL1UwD/H18k6QecZDgSUxPJMAtCpB9/qFTUy5yNO30c1PXJF/H85Ppm8bDOOrvD1txFmqN5qSgwFK/oXFpig6H/ELRYIod+AzTj/kp7FmzXQqpHbfSigzWzEiODXb/MDwacrnHk5I+7a1RCfvNgdqekPD36oV2NInAlTyAx3DAjFnwRcYYNXY760cTxeHiGymVc0GEg5rMGzqbAxo1ix8b0Q X-Microsoft-Antispam: UriScan:; BCL:0; PCL:0; RULEID:; SRVR:BLUPR11MB0675; UriScan:; BCL:0; PCL:0; RULEID:; SRVR:BLUPR11MB0547; X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0; PCL:0; RULEID:(601004)(520003)(5005006)(3002001); SRVR:BLUPR11MB0675; BCL:0; PCL:0; RULEID:; SRVR:BLUPR11MB0675; X-Forefront-PRVS: 06098A2863 X-Forefront-Antispam-Report: SFV:NSPM; SFS:(10009020)(6009001)(479174004)(377454003)(24454002)(5001770100001)(66066001)(42186005)(40100003)(65956001)(15975445007)(80316001)(2950100001)(77096005)(64126003)(47776003)(77156002)(87976001)(86362001)(65806001)(4001350100001)(19580395003)(65816999)(76176999)(122386002)(87266999)(33656002)(62966003)(23746002)(92566002)(50986999)(5001920100001)(93886004)(83506001)(189998001)(36756003)(5001960100002)(46102003)(54356999)(50466002)(59896002)(85282002)(18886065003); DIR:OUT; SFP:1101; SCL:1; SRVR:BLUPR11MB0675; H:decina.local; FPR:; SPF:None; MLV:sfv; LANG:en; X-Microsoft-Exchange-Diagnostics: =?Windows-1252?Q?1; BLUPR11MB0675; 9:4TzIUBmVpbm/j401seOvvnF4o1uCgAQNfsHBvm?= =?Windows-1252?Q?J2YTBc20aWJZcaRdbKAGcoQd+I8AN5GqIxg+MTqDv+bs829V55q5FHN6?= =?Windows-1252?Q?lI1H93Vl8983F/jj0t6/xQ4LUGBq8I9Hh/aiJREnshamB0v/o/QUFqdb?= =?Windows-1252?Q?PqZHEdv0iWfx/334QaCpmKoedHISYg8qxgCz9GF1tWpBHjyB+/d43XUi?= =?Windows-1252?Q?HXzhpuOimNb0dgTj5qVyciXxJnpLNLDyKnSZnYVsPWBvAtPZJk2e6lBi?= =?Windows-1252?Q?LKjRFJebENC87zl5h4Le7MN2XR5NGjhx+yuO923KhTJ+tLhXtSSdQ4Ph?= =?Windows-1252?Q?WUK+yoroYB8AEZm7VYXcVZjH0wSoVaIeOLZUgMrS+Om2KTb3+IkeqZYE?= =?Windows-1252?Q?2A6ycN8d1fg8uxxjnM4cck7s43064LGTFzBDYMBVaeSAlxHEI/pOyzIo?= =?Windows-1252?Q?HVOtHHg/BqlezPL2kwN23ZeL88fW7uqCtHPeNWtrmCq+fVhq/pupeCO+?= =?Windows-1252?Q?IamiDg+B0mJ8G05grhQyaUllhlAZROhrnEkhUSI1JykajZ0GEWJTUquu?= =?Windows-1252?Q?S/uYbUFsn5L+Y+f8yhWWtqRGjsJWHt/Bs/zMTDrp3bzawRaesTBmTfad?= =?Windows-1252?Q?QFENzxhM9jxQT+tPLDwry5VS2IJ4EmvxNW6WInToBvsinflINRrxNRL0?= =?Windows-1252?Q?sR67c5VjYtzit9t3PsNi4xgKL8M6Pq7l/8e2ig6x8u4EbcSmiKTTK8vX?= =?Windows-1252?Q?swfswYfV9I9dkGTszkQG92MW11XNJ4asFAmzQlG0v23O5p1jWeD6tjrZ?= =?Windows-1252?Q?czgR8r7NOu5m9RQBqeH2Oybe/p92oxXJTFQ+XPF9zgDL37UicdA3ZxYY?= =?Windows-1252?Q?mJ0Dh2SY0zCDJMwzGvaJ0Hu/8P2l9/8B/xS0Q9Af3rqysOK09zJySKby?= =?Windows-1252?Q?gisyBG6KnMPGjh6OzrZxPacPpxBmwKPkJyEji0sR9xD+SLPYjYTOuvJP?= =?Windows-1252?Q?+NrXZVi8D4g9NEtKQ9Sch9re6gm+LyDnTzmApM9KUb7JfaxLvQtZNafE?= =?Windows-1252?Q?V8hcvIGzIZ9okXaeGrF5MTc8AFEhH/H5rRYMNW48VTb2DmkYOBGR5ekL?= =?Windows-1252?Q?1PKvzDYhO8a1pXwEWL6J2jgLJ8/6+rJhtmX8IXg7E6KQUe2bWxUjTDZI?= =?Windows-1252?Q?1L3MQCoI8ZPScxHjQ1ZGRORgaXB0E=3D?= X-Microsoft-Exchange-Diagnostics: 1; BLUPR11MB0675; 3:xMOGS37dx3W/vPi4CoIsMO/p/kuDv30uglBSbwNkhdYGbURtfOKRhi4WbPHNMhDY8ANaQ0m3aJZsiv2YvyxjVfH144IsxV7/XrLF9ekEBRI3Y+uWIzkJkth6mWmOjhb0e6CGpDsuk5o1rseohAwCMQ==; 10:ZP7hHfgl88lsL9Zje+pO7IR4804UgLy5eJz/gbRWEHeLZaSQUAOYHx9asg2DYGqVb6VWUu4+o1Tc21UpNXAtKPvlKLCaSI5taHBP6T6uQIM=; 6:j1alDkQ+Gink/kFZtou48twg4MYqIrGzPmjme9Lu0h1uxHSjGqjsvwuvaaZN7zEA X-MS-Exchange-CrossTenant-OriginalArrivalTime: 16 Jun 2015 06:16:21.2577 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: BLUPR11MB0675 X-Microsoft-Exchange-Diagnostics: 1; BLUPR11MB0547; 2:Ix1PLcrl3JUSFBpGJhF2x6OO3ue4zKSDkJykGX2MlAZjmASvP5uYsIadKalL7cxl; 2:zTjFbz9o0GAY7aG3eUn34YxLNOgxFpZ4moki8rYpMfu9MGPE2hjgVtRgd1m+0VgtzrncVRyWpcL9u0dpo0dckds8g4Q36Bhfm0CE+uTlgGSpvHUw8t+zn5WXqFpm7yvEbdYTPakMtVAbjTuaNgQIVQ==; 9:e5Z/0UFjGltPjPuNCbIRaK0Z4BzipGhIltn4T95ey+ypJA80G6k4GyCVwUdWTl14QRFyfECNC9Dp1FlYqNuvFrUQnw05FaiwxFr8xzEmII9U2xGpdH6umcH5BigCoAMHQE5SgNBQoY7bTDZ7F78f4g== X-OriginatorOrg: bluetreble.com X-Pg-Spam-Score: -0.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 On 6/14/15 9:50 AM, Alvaro Herrera wrote: > + values[0] = MultiXactState->oldestMultiXactId; What about oldestOffset and offsetStopLimit? Seems those would be useful too. Looks good other than that. -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers