Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e4Mcv-0000XW-3B for pgsql-sql@arkaria.postgresql.org; Tue, 17 Oct 2017 07:49:25 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e4Mcu-0002Yy-JH for pgsql-sql@arkaria.postgresql.org; Tue, 17 Oct 2017 07:49:24 +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 1e4Mct-0002Xw-JF; Tue, 17 Oct 2017 07:49:23 +0000 Received: from mtagatec.edf.fr ([163.114.23.150]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e4Mcm-00030k-23; Tue, 17 Oct 2017 07:49:22 +0000 X-IronPort-AV: E=Sophos;i="5.43,389,1503352800"; d="scan'208";a="68239207" Received: from unknown (HELO webmail.intranet.edf.com) ([10.22.152.184]) by PCYDMZPIRGW003-back.edf.fr with ESMTP; 17 Oct 2017 09:49:11 +0200 Received: from PCYINTPEXMU001.NEOPROD.EDF.FR (10.22.152.238) by PCYINTPEXMU011.NEOPROD.EDF.FR (10.22.152.184) with Microsoft SMTP Server (TLS) id 15.0.1320.4; Tue, 17 Oct 2017 09:49:05 +0200 Received: from PCYINTPEXMU001.NEOPROD.EDF.FR (10.22.152.238) by PCYINTPEXMU001.NEOPROD.EDF.FR (10.22.152.238) with Microsoft SMTP Server (TLS) id 15.0.1320.4; Tue, 17 Oct 2017 09:49:05 +0200 Received: from PCYINTPEXMU001.NEOPROD.EDF.FR ([fe80::7c46:e173:1600:e88f]) by PCYINTPEXMU001.NEOPROD.EDF.FR ([fe80::7c46:e173:1600:e88f%14]) with mapi id 15.00.1320.000; Tue, 17 Oct 2017 09:49:04 +0200 From: ROS Didier To: "pgsql-sql-owner@postgresql.org" , "pgsql-sql@postgresql.org" Subject: Re: How to index encrypted colums ? Thread-Topic: [SQL] How to index encrypted colums ? Thread-Index: AdNGg3n6U2h+0PXUSj+2I6t4SnZhwQAEWfrgACGrXqA= Date: Tue, 17 Oct 2017 07:49:04 +0000 Message-ID: <210ad7c4549047efa60e645ed0cbb780@PCYINTPEXMU001.NEOPROD.EDF.FR> References: <5e98beca22bc4b7091d34b3bfe8d0306@PCYINTPEXMU001.NEOPROD.EDF.FR> In-Reply-To: Accept-Language: fr-FR, en-US Content-Language: fr-FR X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.22.153.69] x_exchange_neo: 1 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org SGkgS2xhdXMNCg0KCVdlIG5lZWQgZW5jcnlwdGlvbiBiZWNhdXNlIHdlIG5l ZWQgdG8gcHJvdGVjdCBzZW5zaXRpdmUgZGF0YS4gSSBuZWVkIHRvIGNyZWF0 ZSBhbiBpbmRleCBvbiBlbmNyeXB0ZWQgY29sdW1ucyBhbmQgSSBkb24ndCBr bm93IGhvdyB0byBpbnNlcnQgcHJpdmF0ZSBrZXkuDQpFeGFtcGxlOg0KQ1JF QVRFIElOREVYIGNhcnRlZGVjcmVkaXRfY2NfaWR4IE9OIGNhcnRlZGVjcmVk aXQocGdwX3B1Yl9kZWNyeXB0KGNjLCAnLS0tLS0tLS0nKSk7DQoNCkJlc3Qg UmVnYXJkcw0KRGlkaWVyIFJPUyANCkRTUC9DU1AgSVQtRE1BL1NvbHV0aW9u cyBHcm91cGUgRURGL0V4cGVydGlzZSBBcHBsaWNhdGl2ZQ0KRXhwZXJ0aXNl IFNHQkQNCjMyIEF2ZW51ZSBQYWJsbyBQaWNhc3NvDQo5MjAwMCBOQU5URVJS RSANCkJ1cmVhdcKgOiBFMiA1NjVEIChhaWxlIE5vcmQtRXN0KQ0KVMOpbC4g OiAwMS43OC42Ni42MS4xNA0KDQotLS0tLU1lc3NhZ2UgZCdvcmlnaW5lLS0t LS0NCkRlwqA6IHBnc3FsLXNxbC1vd25lckBwb3N0Z3Jlc3FsLm9yZyBbbWFp bHRvOnBnc3FsLXNxbC1vd25lckBwb3N0Z3Jlc3FsLm9yZ10gDQpFbnZvecOp wqA6IGx1bmRpIDE2IG9jdG9icmUgMjAxNyAxNzo0Nw0Kw4DCoDogcGdzcWwt c3FsLW93bmVyQHBvc3RncmVzcWwub3JnOyBwZ3NxbC1zcWxAcG9zdGdyZXNx bC5vcmcNCk9iamV0wqA6IFJlOiBbU1FMXSBIb3cgdG8gaW5kZXggZW5jcnlw dGVkIGNvbHVtcyA/DQoNCldoYXQgaXMgdGhlIHBvaW50IG9mIGVuY3J5cHRp bmcgYSBjb2x1bW4gaW4gdGhlIGZpcnN0IHBsYWNlLCBpZiB5b3UgdGhlbiB3 YW50IHRvIHN0b3JlIHRoZSBpbmRleCBkYXRhIHVuZW5jcnlwdGVkPw0KLUts YXVzDQoNCkZyb206IHBnc3FsLXNxbC1vd25lckBwb3N0Z3Jlc3FsLm9yZyBb bWFpbHRvOnBnc3FsLXNxbC1vd25lckBwb3N0Z3Jlc3FsLm9yZ10gT24gQmVo YWxmIE9mIFJPUyBEaWRpZXINClNlbnQ6IE1vbmRheSwgT2N0b2JlciAxNiwg MjAxNyAzOjM4IFBNDQpUbzogcGdzcWwtc3FsLW93bmVyQHBvc3RncmVzcWwu b3JnOyBwZ3NxbC1zcWxAcG9zdGdyZXNxbC5vcmcNClN1YmplY3Q6IFtTUUxd IEhvdyB0byBpbmRleCBlbmNyeXB0ZWQgY29sdW1zID8NCg0KSGkNCsKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgSSB3b3VsZCB0byBjcmVhdGUgYW4g aW5kZXggb24gYW4gZW5jcnlwdGVkIGNvbHVtbiA6DQoNCkNSRUFURSBJTkRF WCBjYXJ0ZWRlY3JlZGl0X2NjX2lkeCBPTiBjYXJ0ZWRlY3JlZGl0KHBncF9w dWJfZGVjcnlwdChjYywgJy0tLS0tLS0tJykpOw0KDQpIb3cgY2FuIEkgZG8g dG8gaW5kaWNhdGUgdGhlIHByaXZhdGUga2V5ICctLS0tLS0tLSfCoCBpbiB0 aGUgc3FsIHF1ZXJ5ID8NCg0KVGhhbmtzIGluIGFkdmFuY2UNCg0KQmVzdCBS ZWdhcmRzDQoNCkRpZGllciBST1MNCkRTUC9DU1AgSVQtRE1BL1NvbHV0aW9u cyBHcm91cGUgRURGL0V4cGVydGlzZSBBcHBsaWNhdGl2ZSBFeHBlcnRpc2Ug U0dCRA0KMzIgQXZlbnVlIFBhYmxvIFBpY2Fzc28NCjkyMDAwIE5BTlRFUlJF DQpCdXJlYXXCoDogRTIgNTY1RCAoYWlsZSBOb3JkLUVzdCkNClTDqWwuIDog MDEuNzguNjYuNjEuMTQNClTDqWwuIG1vYmlsZSA6IDA2LjQ5LjUxLjExLjg4 DQoNCkNlIG1lc3NhZ2UgZXQgdG91dGVzIGxlcyBwacOoY2VzIGpvaW50ZXMg KGNpLWFwcsOocyBsZSAnTWVzc2FnZScpIHNvbnQgw6l0YWJsaXMgw6AgbCdp bnRlbnRpb24gZXhjbHVzaXZlIGRlcyBkZXN0aW5hdGFpcmVzIGV0IGxlcyBp bmZvcm1hdGlvbnMgcXVpIHkgZmlndXJlbnQgc29udCBzdHJpY3RlbWVudCBj b25maWRlbnRpZWxsZXMuIFRvdXRlIHV0aWxpc2F0aW9uIGRlIGNlIE1lc3Nh Z2Ugbm9uIGNvbmZvcm1lIMOgIHNhIGRlc3RpbmF0aW9uLCB0b3V0ZSBkaWZm dXNpb24gb3UgdG91dGUgcHVibGljYXRpb24gdG90YWxlIG91IHBhcnRpZWxs ZSwgZXN0IGludGVyZGl0ZSBzYXVmIGF1dG9yaXNhdGlvbiBleHByZXNzZS4N ClNpIHZvdXMgbifDqnRlcyBwYXMgbGUgZGVzdGluYXRhaXJlIGRlIGNlIE1l c3NhZ2UsIGlsIHZvdXMgZXN0IGludGVyZGl0IGRlIGxlIGNvcGllciwgZGUg bGUgZmFpcmUgc3VpdnJlLCBkZSBsZSBkaXZ1bGd1ZXIgb3UgZCdlbiB1dGls aXNlciB0b3V0IG91IHBhcnRpZS4gU2kgdm91cyBhdmV6IHJlw6d1IGNlIE1l c3NhZ2UgcGFyIGVycmV1ciwgbWVyY2kgZGUgbGUgc3VwcHJpbWVyIGRlIHZv dHJlIHN5c3TDqG1lLCBhaW5zaSBxdWUgdG91dGVzIHNlcyBjb3BpZXMsIGV0 IGRlIG4nZW4gZ2FyZGVyIGF1Y3VuZSB0cmFjZSBzdXIgcXVlbHF1ZSBzdXBw b3J0IHF1ZSBjZSBzb2l0LiBOb3VzIHZvdXMgcmVtZXJjaW9ucyDDqWdhbGVt ZW50IGQnZW4gYXZlcnRpciBpbW3DqWRpYXRlbWVudCBsJ2V4cMOpZGl0ZXVy IHBhciByZXRvdXIgZHUgbWVzc2FnZS4NCklsIGVzdCBpbXBvc3NpYmxlIGRl IGdhcmFudGlyIHF1ZSBsZXMgY29tbXVuaWNhdGlvbnMgcGFyIG1lc3NhZ2Vy aWUgw6lsZWN0cm9uaXF1ZSBhcnJpdmVudCBlbiB0ZW1wcyB1dGlsZSwgc29u dCBzw6ljdXJpc8OpZXMgb3UgZMOpbnXDqWVzIGRlIHRvdXRlIGVycmV1ciBv dSB2aXJ1cy4NCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX18NClRoaXMgbWVzc2FnZSBhbmQgYW55IGF0dGFj aG1lbnRzICh0aGUgJ01lc3NhZ2UnKSBhcmUgaW50ZW5kZWQgc29sZWx5IGZv ciB0aGUgYWRkcmVzc2Vlcy4gVGhlIGluZm9ybWF0aW9uIGNvbnRhaW5lZCBp biB0aGlzIE1lc3NhZ2UgaXMgY29uZmlkZW50aWFsLiBBbnkgdXNlIG9mIGlu Zm9ybWF0aW9uIGNvbnRhaW5lZCBpbiB0aGlzIE1lc3NhZ2Ugbm90IGluIGFj Y29yZCB3aXRoIGl0cyBwdXJwb3NlLCBhbnkgZGlzc2VtaW5hdGlvbiBvciBk aXNjbG9zdXJlLCBlaXRoZXIgd2hvbGUgb3IgcGFydGlhbCwgaXMgcHJvaGli aXRlZCBleGNlcHQgZm9ybWFsIGFwcHJvdmFsLg0KSWYgeW91IGFyZSBub3Qg dGhlIGFkZHJlc3NlZSwgeW91IG1heSBub3QgY29weSwgZm9yd2FyZCwgZGlz Y2xvc2Ugb3IgdXNlIGFueSBwYXJ0IG9mIGl0LiBJZiB5b3UgaGF2ZSByZWNl aXZlZCB0aGlzIG1lc3NhZ2UgaW4gZXJyb3IsIHBsZWFzZSBkZWxldGUgaXQg YW5kIGFsbCBjb3BpZXMgZnJvbSB5b3VyIHN5c3RlbSBhbmQgbm90aWZ5IHRo ZSBzZW5kZXIgaW1tZWRpYXRlbHkgYnkgcmV0dXJuIG1lc3NhZ2UuDQpFLW1h aWwgY29tbXVuaWNhdGlvbiBjYW5ub3QgYmUgZ3VhcmFudGVlZCB0byBiZSB0 aW1lbHkgc2VjdXJlLCBlcnJvciBvciB2aXJ1cy1mcmVlLg0KDQotLQ0KU2Vu dCB2aWEgcGdzcWwtc3FsIG1haWxpbmcgbGlzdCAocGdzcWwtc3FsQHBvc3Rn cmVzcWwub3JnKSBUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJzY3JpcHRp b246DQpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3Fs LXNxbA0KCgoKQ2UgbWVzc2FnZSBldCB0b3V0ZXMgbGVzIHBpw6hjZXMgam9p bnRlcyAoY2ktYXByw6hzIGxlICdNZXNzYWdlJykgc29udCDDqXRhYmxpcyDD oCBsJ2ludGVudGlvbiBleGNsdXNpdmUgZGVzIGRlc3RpbmF0YWlyZXMgZXQg bGVzIGluZm9ybWF0aW9ucyBxdWkgeSBmaWd1cmVudCBzb250IHN0cmljdGVt ZW50IGNvbmZpZGVudGllbGxlcy4gVG91dGUgdXRpbGlzYXRpb24gZGUgY2Ug TWVzc2FnZSBub24gY29uZm9ybWUgw6Agc2EgZGVzdGluYXRpb24sIHRvdXRl IGRpZmZ1c2lvbiBvdSB0b3V0ZSBwdWJsaWNhdGlvbiB0b3RhbGUgb3UgcGFy dGllbGxlLCBlc3QgaW50ZXJkaXRlIHNhdWYgYXV0b3Jpc2F0aW9uIGV4cHJl c3NlLgoKU2kgdm91cyBuJ8OqdGVzIHBhcyBsZSBkZXN0aW5hdGFpcmUgZGUg Y2UgTWVzc2FnZSwgaWwgdm91cyBlc3QgaW50ZXJkaXQgZGUgbGUgY29waWVy LCBkZSBsZSBmYWlyZSBzdWl2cmUsIGRlIGxlIGRpdnVsZ3VlciBvdSBkJ2Vu IHV0aWxpc2VyIHRvdXQgb3UgcGFydGllLiBTaSB2b3VzIGF2ZXogcmXDp3Ug Y2UgTWVzc2FnZSBwYXIgZXJyZXVyLCBtZXJjaSBkZSBsZSBzdXBwcmltZXIg ZGUgdm90cmUgc3lzdMOobWUsIGFpbnNpIHF1ZSB0b3V0ZXMgc2VzIGNvcGll cywgZXQgZGUgbidlbiBnYXJkZXIgYXVjdW5lIHRyYWNlIHN1ciBxdWVscXVl IHN1cHBvcnQgcXVlIGNlIHNvaXQuIE5vdXMgdm91cyByZW1lcmNpb25zIMOp Z2FsZW1lbnQgZCdlbiBhdmVydGlyIGltbcOpZGlhdGVtZW50IGwnZXhww6lk aXRldXIgcGFyIHJldG91ciBkdSBtZXNzYWdlLgoKSWwgZXN0IGltcG9zc2li bGUgZGUgZ2FyYW50aXIgcXVlIGxlcyBjb21tdW5pY2F0aW9ucyBwYXIgbWVz c2FnZXJpZSDDqWxlY3Ryb25pcXVlIGFycml2ZW50IGVuIHRlbXBzIHV0aWxl LCBzb250IHPDqWN1cmlzw6llcyBvdSBkw6ludcOpZXMgZGUgdG91dGUgZXJy ZXVyIG91IHZpcnVzLgpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fCgpUaGlzIG1lc3NhZ2UgYW5kIGFueSBh dHRhY2htZW50cyAodGhlICdNZXNzYWdlJykgYXJlIGludGVuZGVkIHNvbGVs eSBmb3IgdGhlIGFkZHJlc3NlZXMuIFRoZSBpbmZvcm1hdGlvbiBjb250YWlu ZWQgaW4gdGhpcyBNZXNzYWdlIGlzIGNvbmZpZGVudGlhbC4gQW55IHVzZSBv ZiBpbmZvcm1hdGlvbiBjb250YWluZWQgaW4gdGhpcyBNZXNzYWdlIG5vdCBp biBhY2NvcmQgd2l0aCBpdHMgcHVycG9zZSwgYW55IGRpc3NlbWluYXRpb24g b3IgZGlzY2xvc3VyZSwgZWl0aGVyIHdob2xlIG9yIHBhcnRpYWwsIGlzIHBy b2hpYml0ZWQgZXhjZXB0IGZvcm1hbCBhcHByb3ZhbC4KCklmIHlvdSBhcmUg bm90IHRoZSBhZGRyZXNzZWUsIHlvdSBtYXkgbm90IGNvcHksIGZvcndhcmQs IGRpc2Nsb3NlIG9yIHVzZSBhbnkgcGFydCBvZiBpdC4gSWYgeW91IGhhdmUg cmVjZWl2ZWQgdGhpcyBtZXNzYWdlIGluIGVycm9yLCBwbGVhc2UgZGVsZXRl IGl0IGFuZCBhbGwgY29waWVzIGZyb20geW91ciBzeXN0ZW0gYW5kIG5vdGlm eSB0aGUgc2VuZGVyIGltbWVkaWF0ZWx5IGJ5IHJldHVybiBtZXNzYWdlLgoK RS1tYWlsIGNvbW11bmljYXRpb24gY2Fubm90IGJlIGd1YXJhbnRlZWQgdG8g YmUgdGltZWx5IHNlY3VyZSwgZXJyb3Igb3IgdmlydXMtZnJlZS4KCi0tIApT ZW50IHZpYSBwZ3NxbC1zcWwgbWFpbGluZyBsaXN0IChwZ3NxbC1zcWxAcG9z dGdyZXNxbC5vcmcpClRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1YnNjcmlw dGlvbjoKaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tYWlscHJlZi9wZ3Nx bC1zcWwK