Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f0tql-0006Mw-4E for pgsql-committers@arkaria.postgresql.org; Tue, 27 Mar 2018 19:01:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1f0tqj-0004mk-PR for pgsql-committers@arkaria.postgresql.org; Tue, 27 Mar 2018 19:01:37 +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.89) (envelope-from ) id 1f0tqj-0004mZ-Gt for pgsql-committers@lists.postgresql.org; Tue, 27 Mar 2018 19:01:37 +0000 Received: from mahout.postgresql.org ([2001:4800:1501:1::227]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f0tqg-0005qe-Mb for pgsql-committers@lists.postgresql.org; Tue, 27 Mar 2018 19:01:35 +0000 Received: from gemulon.postgresql.org ([2001:4800:1501:1::198]) by mahout.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1f0tqf-0001fF-U6 for pgsql-committers@lists.postgresql.org; Tue, 27 Mar 2018 19:01:34 +0000 Received: from git by gemulon.postgresql.org with local (Exim 4.89) (envelope-from ) id 1f0tqf-0007Vs-JZ for pgsql-committers@lists.postgresql.org; Tue, 27 Mar 2018 19:01:33 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 To: pgsql-committers@lists.postgresql.org From: Simon Riggs Subject: pgsql: Allow HOT updates for some expression indexes Message-Id: Date: Tue, 27 Mar 2018 19:01:33 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk QWxsb3cgSE9UIHVwZGF0ZXMgZm9yIHNvbWUgZXhwcmVzc2lvbiBpbmRleGVzCgpJZiB0aGUgdmFs dWUgb2YgYW4gaW5kZXggZXhwcmVzc2lvbiBpcyB1bmNoYW5nZWQgYWZ0ZXIgVVBEQVRFLAphbGxv dyBIT1QgdXBkYXRlcyB3aGVyZSBwcmV2aW91c2x5IHdlIGRpc2FsbG93ZWQgdGhlbSwgZ2l2aW5n CmEgc2lnbmlmaWNhbnQgcGVyZm9ybWFuY2UgYm9vc3QgaW4gdGhvc2UgY2FzZXMuCgpQYXJ0aWN1 bGFybHkgdXNlZnVsIGZvciBpbmRleGVzIHN1Y2ggYXMgSlNPTi0+PmZpZWxkIHdoZXJlIHRoZQpK U09OIHZhbHVlIGNoYW5nZXMgYnV0IHRoZSBpbmRleGVkIHZhbHVlIGRvZXMgbm90LgoKU3VibWl0 dGVkIGFzICJzdXJqZWN0aXZlIGluZGV4ZXMiIHBhdGNoLCBub3cgZW5hYmxlZCBieSB1c2UKb2Yg bmV3ICJyZWNoZWNrX29uX3VwZGF0ZSIgcGFyYW1ldGVyLgoKQXV0aG9yOiBLb25zdGFudGluIEtu aXpobmlrClJldmlld2VyOiBTaW1vbiBSaWdncywgd2l0aCBtdWNoIHdvcmRzbWl0aGluZyBhbmQg c29tZSBjbGVhbnVwCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBz Oi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvYzIwM2Q2Y2Y4MWI0ZDdlNDNlZGIy Yjc1ZWMxYjc0MWJhNDhlMDRlMAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KZG9jL3Ny Yy9zZ21sL3JlZi9jcmVhdGVfaW5kZXguc2dtbCAgICAgICB8ICAzNyArKysrKysrKystCnNyYy9i YWNrZW5kL2FjY2Vzcy9jb21tb24vcmVsb3B0aW9ucy5jICAgfCAgNDUgKysrKysrKysrKysrLQpz cmMvYmFja2VuZC9hY2Nlc3MvaGVhcC9oZWFwYW0uYyAgICAgICAgIHwgMTA1ICsrKysrKysrKysr KysrKysrKysrKysrKysrKy0tCnNyYy9iYWNrZW5kL2NhdGFsb2cvaW5kZXguYyAgICAgICAgICAg ICAgfCAgIDMgKy0Kc3JjL2JhY2tlbmQvdXRpbHMvY2FjaGUvcmVsY2FjaGUuYyAgICAgICB8IDEx MiArKysrKysrKysrKysrKysrKysrKysrKysrKysrKy0tCnNyYy9iaW4vcHNxbC90YWItY29tcGxl dGUuYyAgICAgICAgICAgICAgfCAgIDQgKy0Kc3JjL2luY2x1ZGUvYWNjZXNzL3JlbG9wdGlvbnMu aCAgICAgICAgICB8ICAgMiArCnNyYy9pbmNsdWRlL3V0aWxzL3JlbC5oICAgICAgICAgICAgICAg ICAgfCAgMTIgKysrLQpzcmMvaW5jbHVkZS91dGlscy9yZWxjYWNoZS5oICAgICAgICAgICAgIHwg ICAzICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvZnVuY19pbmRleC5vdXQgfCAgNjEgKysr KysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9wYXJhbGxlbF9zY2hlZHVsZSAgICAgICB8 ICAgMiArLQpzcmMvdGVzdC9yZWdyZXNzL3NlcmlhbF9zY2hlZHVsZSAgICAgICAgIHwgICAxICsK c3JjL3Rlc3QvcmVncmVzcy9zcWwvZnVuY19pbmRleC5zcWwgICAgICB8ICAzMCArKysrKysrKysK MTMgZmlsZXMgY2hhbmdlZCwgMzk1IGluc2VydGlvbnMoKyksIDIyIGRlbGV0aW9ucygtKQoK