Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dnYmO-00088u-Sk for pgsql-bugs@arkaria.postgresql.org; Thu, 31 Aug 2017 23:21:45 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dnYmO-0003Dg-B6 for pgsql-bugs@arkaria.postgresql.org; Thu, 31 Aug 2017 23:21:44 +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 1dnYlf-0001zH-Fz for pgsql-bugs@postgresql.org; Thu, 31 Aug 2017 23:20:59 +0000 Received: from smtp-fw-9102.amazon.com ([207.171.184.29]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dnYlb-0001pE-6w for pgsql-bugs@postgresql.org; Thu, 31 Aug 2017 23:20:58 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1504221655; x=1535757655; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-id:content-transfer-encoding: mime-version; bh=aJfm7yyTzSvlGjXZCv/0+psIvsBy3bi+/N8oepQ1JoQ=; b=ZM+g0l3GtAndTN/i+gzfUEkDKJISQyvPhjkPJwqJTRDervqZZm2gz/LE rvwBhWAJNLa9SDtls9t4f4ppCut8F7yqOKFTUpZpptIiyFIm/RexVgik/ xWv+Os727AzT/xlYZHz1iqataQ3I+TGXLHITkV7Nh1u3YOECV8jb6jHTh M=; X-IronPort-AV: E=Sophos;i="5.41,455,1498521600"; d="scan'208";a="563671320" Received: from sea3-co-svc-lb6-vlan3.sea.amazon.com (HELO email-inbound-relay-1d-474bcd9f.us-east-1.amazon.com) ([10.47.22.38]) by smtp-border-fw-out-9102.sea19.amazon.com with ESMTP/TLS/DHE-RSA-AES256-SHA; 31 Aug 2017 23:20:23 +0000 Received: from EX13MTAUWC001.ant.amazon.com (iad55-ws-svc-p15-lb9-vlan2.iad.amazon.com [10.40.159.162]) by email-inbound-relay-1d-474bcd9f.us-east-1.amazon.com (8.14.7/8.14.7) with ESMTP id v7VNK4Vx077414 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=FAIL); Thu, 31 Aug 2017 23:20:08 GMT Received: from EX13D11UWC004.ant.amazon.com (10.43.162.101) by EX13MTAUWC001.ant.amazon.com (10.43.162.135) with Microsoft SMTP Server (TLS) id 15.0.1104.5; Thu, 31 Aug 2017 23:20:05 +0000 Received: from EX13D11UWC002.ant.amazon.com (10.43.162.174) by EX13D11UWC004.ant.amazon.com (10.43.162.101) with Microsoft SMTP Server (TLS) id 15.0.1104.5; Thu, 31 Aug 2017 23:20:04 +0000 Received: from EX13D11UWC002.ant.amazon.com ([10.43.162.174]) by EX13D11UWC002.ant.amazon.com ([10.43.162.174]) with mapi id 15.00.1104.000; Thu, 31 Aug 2017 23:20:04 +0000 From: "Wood, Dan" To: Peter Geoghegan CC: "pgsql-bugs@postgresql.org" Subject: Re: Old row version in hot chain become visible after a freeze Thread-Topic: [BUGS] Old row version in hot chain become visible after a freeze Thread-Index: AQHTIqmfEH9T5bMCDUufad1KxDA7S6KfE2UA//+RSAA= Date: Thu, 31 Aug 2017 23:20:04 +0000 Message-ID: <897E6768-98C1-43C5-B743-DF060A7C2D0E@amazon.com> References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.162.81] Content-Type: text/plain; charset="utf-8" Content-ID: <8E7B3570EEF87E4193471F4E89007053@amazon.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 Precedence: Bulk 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 SSB3YXMgYXdhcmUgb2YgdGhlIG90aGVyIG9uZSBhbmQsIGluIGZhY3QsIHJl dmVydGVkIHRoZSBjaGFuZ2UganVzdCB0byBtYWtlIHN1cmUgaXQgd2FzbuKA mXQgSW52b2x2ZWQuICBBIHN0cmFuZ2UgY29pbmNpZGVuY2UgaW5kZWVkLg0K DQpPbiA4LzMxLzE3LCAzOjU3IFBNLCAiUGV0ZXIgR2VvZ2hlZ2FuIiA8cGdA Ym93dC5pZT4gd3JvdGU6DQoNCiAgICBIaSBEYW4sDQogICAgDQogICAgTmlj ZSB0byBoZWFyIGZyb20geW91Lg0KICAgIA0KICAgIE9uIFRodSwgQXVnIDMx LCAyMDE3IGF0IDM6MzYgUE0sIFdvb2QsIERhbiA8aGV4cGVydEBhbWF6b24u Y29tPiB3cm90ZToNCiAgICA+IEJlY2F1c2UgdHVwZ29uZSBpcyBmYWxzZSB3 ZSBmcmVlemUgaW5zdGVhZCBvZiBkZWxldGluZy4gIEZyZWV6aW5nIGEgREVB RA0KICAgID4gdHVwbGUgbWFrZXMgaXQgdmlzaWJsZS4gIEhlcmUgaXMgYSBj b21tZW50IGluIGhlYXBfcHJlcGFyZV9mcmVlemVfdHVwbGUoKQ0KICAgID4N CiAgICA+DQogICAgPg0KICAgID4gICAqIEl0IGlzIGFzc3VtZWQgdGhhdCB0 aGUgY2FsbGVyIGhhcyBjaGVja2VkIHRoZSB0dXBsZSB3aXRoDQogICAgPg0K ICAgID4gICAqIEhlYXBUdXBsZVNhdGlzZmllc1ZhY3V1bSgpIGFuZCBkZXRl cm1pbmVkIHRoYXQgaXQgaXMgbm90IEhFQVBUVVBMRV9ERUFEDQogICAgDQog ICAgRnVubnkgdGhhdCB0aGVyZSdkIGJlIGFub3RoZXIgYnVnIGFzc29jaWF0 ZWQgd2l0aA0KICAgIGhlYXBfcHJlcGFyZV9mcmVlemVfdHVwbGUoKSBzbyBz b29uIGFmdGVyIHRoZSBsYXN0IG9uZSB3YXMgZGlzY292ZXJlZC4NCiAgICBB cmUgeW91IGF3YXJlIG9mIHRoZSBvdGhlciBvbmUgWzFdPw0KICAgIA0KICAg IEJUVywgSSBqdXN0IHBvc3RlZCBhIHBhdGNoIHRvIGVuaGFuY2UgYW1jaGVj aywgdG8gYWxsb3cgaXQgdG8gdmVyaWZ5DQogICAgdGhhdCBhbiBpbmRleCBo YXMgYWxsIHRoZSBlbnRyaWVzIHRoYXQgaXQgb3VnaHQgdG8gWzJdLiBQZXJo YXBzIHlvdSdkDQogICAgZmluZCBpdCB1c2VmdWwgZm9yIHRoaXMga2luZCBv ZiB0aGluZy4gSSB3ZWxjb21lIHlvdXIgZmVlZGJhY2sgb24NCiAgICB0aGF0 Lg0KICAgIA0KICAgIFsxXSBodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9n aXR3ZWIvP3A9cG9zdGdyZXNxbC5naXQ7YT1jb21taXRkaWZmO2g9MzFiOGRi OGU2YzFmYTQ0MzYxMTZmNGJlNWNhNzg5ZjNhMDFiOWViZjtocD1mMWRhZTA5 N2YyOTQ1ZmZjYjU5YTlmMjM2ODQzZTBlMGJiZjA5MjBkDQogICAgWzJdIGh0 dHBzOi8vY29tbWl0ZmVzdC5wb3N0Z3Jlc3FsLm9yZy8xNC8xMjYzLw0KICAg IC0tIA0KICAgIFBldGVyIEdlb2doZWdhbg0KICAgIA0KDQoKLS0gClNlbnQg dmlhIHBnc3FsLWJ1Z3MgbWFpbGluZyBsaXN0IChwZ3NxbC1idWdzQHBvc3Rn cmVzcWwub3JnKQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJzY3JpcHRp b246Cmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdzcWwt YnVncwo=