Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g9UFb-0004uN-4r for pgsql-general@arkaria.postgresql.org; Mon, 08 Oct 2018 12:03:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g9UFZ-0006eg-GH for pgsql-general@arkaria.postgresql.org; Mon, 08 Oct 2018 12:03:01 +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 1g9UFZ-0006eY-3x for pgsql-general@lists.postgresql.org; Mon, 08 Oct 2018 12:03:01 +0000 Received: from mtagatea.edf.fr ([163.114.23.130]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g9UFU-0005DG-92 for pgsql-general@lists.postgresql.org; Mon, 08 Oct 2018 12:02:59 +0000 From: ROS Didier To: "phil_tnlcz_endecott@chezphil.org" , "pgsql-general@lists.postgresql.org" Subject: RE: Why the index is not used ? Thread-Topic: Why the index is not used ? Thread-Index: AdRdWvsLq5pbGc6hRyec/3F+ZHcFNP//4vmA//5l9yCAA4zAgP//vN6QgAB6fYD//sjHkA== Date: Mon, 8 Oct 2018 12:02:50 +0000 Message-ID: <0f723a9063f14e2096eb36e720a8048b@PCYINTPEXMU001.NEOPROD.EDF.FR> References: <3a14f7f8fbda4e868b663b31e8c5fa16@PCYINTPEXMU001.NEOPROD.EDF.FR> <1538939797640@dmwebmail.dmwebmail.chezphil.org> In-Reply-To: <1538939797640@dmwebmail.dmwebmail.chezphil.org> 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.70] x_exchange_neo: 1 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk SGkgUGhpbA0KDQoJVGhhbmsgeW91IGZvciB0aGlzIHJlY29tbWVuZGF0aW9uLCBidXQgSSBwb3N0 ZWQgb24gdGhpcyBwdWJsaWMgbGlzdCBvbmx5IGdlbmVyaWMgZXhhbXBsZXMgdGhhdCBoYXZlIG5v dGhpbmcgdG8gZG8gd2l0aCB0aGUgd29ya3MgZG9uZSBpbiBteSBjb21wYW55Lg0KCVRoZXNlIGV4 YW1wbGVzIHNlcnZlIG1lIG9ubHkgdG8gZGlzY3VzcyBhYm91dCB0aGUgc3ViamVjdCBvZiBkYXRh IGVuY3J5cHRpb24gYW5kIHBlcmZvcm1hbmNlDQoJTXkgYW5zd2VycyB0byB5b3VyIHJlbWFya3Mg Og0KDQo+Pg0KV2h5IGRvIHlvdSBuZWVkIHRvIHNlYXJjaCBieSBjcmVkaXQgY2FyZCBudW1iZXI/ DQo8PA0KIEFnYWluLCB0aGlzIGlzIGp1c3QgYW4gZXhhbXBsZS4gSSBqdXN0IHdhbnQgdG8gZmlu ZCBhIHNvbHV0aW9uIHRvIHF1ZXJ5IGEgY29sdW1uIGNvbnRhaW5pbmcgZW5jcnlwdGVkIGRhdGEg d2l0aCBnb29kIHBlcmZvcm1hbmNlLg0KDQo+Pg0Kb25lIG9wdGlvbiBpcyB0byB1c2UgYW4gZW5j cnlwdGlvbiBmdW5jdGlvbiB0aGF0IGRvZXNuJ3Qgc2FsdCB0aGUgZGF0YQ0KPDwNCkkgYW0gaW50 ZXJlc3RlZC4gQ2FuIHlvdSBnaXZlIHNvbWUgZXhhbXBsZXMgb2YgdGhlc2UgZW5jcnlwdGlvbiBm dW5jdGlvbiB0aGF0IGRvZXNuJ3Qgc2FsdCB0aGUgZGF0YS4NCg0KQmVzdCBSZWdhcmRzDQpEaWRp ZXIgUk9TDQotLS0tLU1lc3NhZ2UgZCdvcmlnaW5lLS0tLS0NCkRlwqA6IHBoaWxfdG5sY3pfZW5k ZWNvdHRAY2hlenBoaWwub3JnIFttYWlsdG86cGhpbF90bmxjel9lbmRlY290dEBjaGV6cGhpbC5v cmddIA0KRW52b3nDqcKgOiBkaW1hbmNoZSA3IG9jdG9icmUgMjAxOCAyMToxNw0Kw4DCoDogUk9T IERpZGllciA8ZGlkaWVyLnJvc0BlZGYuZnI+OyBwZ3NxbC1nZW5lcmFsQGxpc3RzLnBvc3RncmVz cWwub3JnDQpPYmpldMKgOiBSRTogV2h5IHRoZSBpbmRleCBpcyBub3QgdXNlZCA/DQoNCkhlbGxv IERpZGllciwNCg0KWW91ciBlbWFpbCBpcyBkaWRpZXIucm9zQGVkZi5mci4gIEFyZSB5b3Ugd29y a2luZyBhdCBFbGVjdHJpY2l0ZSBkZSBGcmFuY2UsIGFuZCBzdG9yaW5nIGFjdHVhbCBjdXN0b21l cnMnIGNyZWRpdCBjYXJkIGRldGFpbHM/ICBIb3cgbWFueSBtaWxsaW9ucyBvZiB0aGVtPw0KDQpO b3RlIHRoYXQgdGhpcyBtYWlsaW5nIGxpc3QgaXMgcHVibGljOyBwZW9wbGUgbG9va2luZyBmb3Ig dGFyZ2V0cyB3aXRoIHBvb3Igc2VjdXJpdHkgZnJvbSB3aGljaCB0aGV5IGNhbiBoYXJ2ZXN0IGNy ZWRpdCBjYXJkIG51bWJlcnMgbWlnaHQgYmUgcmVhZGluZyBpdC4NCkFuZCBhZnRlciB5b3UgYXJl IGhhY2tlZCBhbmQgYWxsIHlvdXIgY3VzdG9tZXJzJyBjcmVkaXQgY2FyZCBkZXRhaWxzIGFyZSBt YWRlIHB1YmxpYywgc29tZW9uZSB3aWxsIGZpbmQgdGhpcyB0aHJlYWQuDQoNCj4gaXQncyBub3Qg dGhlIGJlc3Qgc29sdXRpb24sIGJ1dCB3ZSBoYXZlIGRhdGEgZW5jcnlwdGlvbiBuZWVkcyBhbmQg Z29vZCANCj4gcGVyZm9ybWFuY2UgbmVlZHMgdG9vLiBJIGRvIG5vdCBrbm93IGhvdyB0byBkbyBp dCBleGNlcHQgdGhlIHNwZWNpZmllZCANCj4gcHJvY2VkdXJlLi4NCg0KWW91IHNob3VsZCBwcm9i YWJseSBlbXBsb3kgc29tZW9uZSB3aG8ga25vd3Mgd2hhdCB0aGV5IGFyZSBkb2luZy4NCg0KU29y cnkgZm9yIGJlaW5nIHNvIGRpcmVjdCwgYnV0IHJlYWxseS4uLiBzdG9yaW5nIGxhcmdlIHF1YW50 aXRpZXMgb2YgY3JlZGl0IGNhcmQgZGV0YWlscyBpcyB0aGUgdGV4dCBib29rIGV4YW1wbGUgb2Yg c29tZXRoaW5nIHRoYXQgaGFzIHRvIGJlIGRvbmUgY29ycmVjdGx5Lg0KDQo+IGlmIGFueW9uZSBo YXMgYW55IHByb3Bvc2FscyB0byBwdXQgdGhpcyBpbiBwbGFjZSwgSSdtIGludGVyZXN0ZWQuDQoN CldoeSBkbyB5b3UgbmVlZCB0byBzZWFyY2ggYnkgY3JlZGl0IGNhcmQgbnVtYmVyPw0KDQpJZiB5 b3UgcmVhbGx5IHJlYWxseSBuZWVkIHRvIGRvIHRoYXQsIHRoZW4gb25lIG9wdGlvbiBpcyB0byB1 c2UgYW4gZW5jcnlwdGlvbiBmdW5jdGlvbiB0aGF0IGRvZXNuJ3Qgc2FsdCB0aGUgZGF0YS4gIE9y IHlvdSBjb3VsZCBzdG9yZSBwYXJ0IG9mIHRoZSBudW1iZXIgKGxhc3QgNCBkaWdpdHM/KSwgb3Ig YW4gdW5zYWx0ZWQgaGFzaCBvZiB0aGUgbnVtYmVyLCB1bmVuY3J5cHRlZCBhbmQgaW5kZXhlZCwg YW5kIHRoZW4geW91IG5lZWQgb25seSB0byBzZXF1ZW50aWFsbHkgZGVjcnlwdCAodXNpbmcgdGhl IHNhbHRlZCBlbmNyeXB0aW9uKSBlLmcuIDEvMTAwMDAgb2YgdGhlIGNhcmQgbnVtYmVycy4gIEJ1 dCB0aGVyZSBhcmUgY29tcGxleCBzZWN1cml0eSBpc3N1ZXMgYW5kIHRyYWRlb2ZmcyBpbnZvbHZl ZCBoZXJlLiAgWW91IHByb2JhYmx5IG5lZWQgdG8gY29tcGx5IHdpdGggcmVndWxhdGlvbnMgKGUu Zy4gIlBDSSBzdGFuZGFyZHMiKSB3aGljaCB3aWxsIHNwZWNpZnkgd2hhdCBpcyBhbGxvd2VkIGFu ZCB3aGF0IGlzbid0LiBBbmQgaWYgeW91IGRpZG4ndCBhbHJlYWR5IGtub3cgdGhhdCwgeW91IHNo b3VsZG4ndCBiZSBkb2luZyB0aGlzLg0KDQoNCkdvb2QgbHVjaywgSSBzdXBwb3NlLg0KDQpQaGls Lg0KDQpQLlMuIEl0IHNlZW1zIHRoYXQgeW91IHdlcmUgYXNraW5nIGFib3V0IHRoaXMgYSB5ZWFy IGFnbywgYW5kIGdvdCB0aGUgc2FtZSBhbnN3ZXJzLi4uDQoNCg0KDQoNCgoKCkNlIG1lc3NhZ2Ug ZXQgdG91dGVzIGxlcyBwacOoY2VzIGpvaW50ZXMgKGNpLWFwcsOocyBsZSAnTWVzc2FnZScpIHNv bnQgw6l0YWJsaXMgw6AgbCdpbnRlbnRpb24gZXhjbHVzaXZlIGRlcyBkZXN0aW5hdGFpcmVzIGV0 IGxlcyBpbmZvcm1hdGlvbnMgcXVpIHkgZmlndXJlbnQgc29udCBzdHJpY3RlbWVudCBjb25maWRl bnRpZWxsZXMuIFRvdXRlIHV0aWxpc2F0aW9uIGRlIGNlIE1lc3NhZ2Ugbm9uIGNvbmZvcm1lIMOg IHNhIGRlc3RpbmF0aW9uLCB0b3V0ZSBkaWZmdXNpb24gb3UgdG91dGUgcHVibGljYXRpb24gdG90 YWxlIG91IHBhcnRpZWxsZSwgZXN0IGludGVyZGl0ZSBzYXVmIGF1dG9yaXNhdGlvbiBleHByZXNz ZS4KClNpIHZvdXMgbifDqnRlcyBwYXMgbGUgZGVzdGluYXRhaXJlIGRlIGNlIE1lc3NhZ2UsIGls IHZvdXMgZXN0IGludGVyZGl0IGRlIGxlIGNvcGllciwgZGUgbGUgZmFpcmUgc3VpdnJlLCBkZSBs ZSBkaXZ1bGd1ZXIgb3UgZCdlbiB1dGlsaXNlciB0b3V0IG91IHBhcnRpZS4gU2kgdm91cyBhdmV6 IHJlw6d1IGNlIE1lc3NhZ2UgcGFyIGVycmV1ciwgbWVyY2kgZGUgbGUgc3VwcHJpbWVyIGRlIHZv dHJlIHN5c3TDqG1lLCBhaW5zaSBxdWUgdG91dGVzIHNlcyBjb3BpZXMsIGV0IGRlIG4nZW4gZ2Fy ZGVyIGF1Y3VuZSB0cmFjZSBzdXIgcXVlbHF1ZSBzdXBwb3J0IHF1ZSBjZSBzb2l0LiBOb3VzIHZv dXMgcmVtZXJjaW9ucyDDqWdhbGVtZW50IGQnZW4gYXZlcnRpciBpbW3DqWRpYXRlbWVudCBsJ2V4 cMOpZGl0ZXVyIHBhciByZXRvdXIgZHUgbWVzc2FnZS4KCklsIGVzdCBpbXBvc3NpYmxlIGRlIGdh cmFudGlyIHF1ZSBsZXMgY29tbXVuaWNhdGlvbnMgcGFyIG1lc3NhZ2VyaWUgw6lsZWN0cm9uaXF1 ZSBhcnJpdmVudCBlbiB0ZW1wcyB1dGlsZSwgc29udCBzw6ljdXJpc8OpZXMgb3UgZMOpbnXDqWVz IGRlIHRvdXRlIGVycmV1ciBvdSB2aXJ1cy4KX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fXwoKVGhpcyBtZXNzYWdlIGFuZCBhbnkgYXR0YWNobWVudHMg KHRoZSAnTWVzc2FnZScpIGFyZSBpbnRlbmRlZCBzb2xlbHkgZm9yIHRoZSBhZGRyZXNzZWVzLiBU aGUgaW5mb3JtYXRpb24gY29udGFpbmVkIGluIHRoaXMgTWVzc2FnZSBpcyBjb25maWRlbnRpYWwu IEFueSB1c2Ugb2YgaW5mb3JtYXRpb24gY29udGFpbmVkIGluIHRoaXMgTWVzc2FnZSBub3QgaW4g YWNjb3JkIHdpdGggaXRzIHB1cnBvc2UsIGFueSBkaXNzZW1pbmF0aW9uIG9yIGRpc2Nsb3N1cmUs IGVpdGhlciB3aG9sZSBvciBwYXJ0aWFsLCBpcyBwcm9oaWJpdGVkIGV4Y2VwdCBmb3JtYWwgYXBw cm92YWwuCgpJZiB5b3UgYXJlIG5vdCB0aGUgYWRkcmVzc2VlLCB5b3UgbWF5IG5vdCBjb3B5LCBm b3J3YXJkLCBkaXNjbG9zZSBvciB1c2UgYW55IHBhcnQgb2YgaXQuIElmIHlvdSBoYXZlIHJlY2Vp dmVkIHRoaXMgbWVzc2FnZSBpbiBlcnJvciwgcGxlYXNlIGRlbGV0ZSBpdCBhbmQgYWxsIGNvcGll cyBmcm9tIHlvdXIgc3lzdGVtIGFuZCBub3RpZnkgdGhlIHNlbmRlciBpbW1lZGlhdGVseSBieSBy ZXR1cm4gbWVzc2FnZS4KCkUtbWFpbCBjb21tdW5pY2F0aW9uIGNhbm5vdCBiZSBndWFyYW50ZWVk IHRvIGJlIHRpbWVseSBzZWN1cmUsIGVycm9yIG9yIHZpcnVzLWZyZWUuCg==