Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iNgwM-0005Ue-On for pgsql-docs@arkaria.postgresql.org; Thu, 24 Oct 2019 17:30:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iNgwJ-0007ec-Eh for pgsql-docs@arkaria.postgresql.org; Thu, 24 Oct 2019 17:30:23 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1iNesJ-0007lo-JF for pgsql-docs@lists.postgresql.org; Thu, 24 Oct 2019 15:18:07 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iNesG-0002BX-Q0 for pgsql-docs@lists.postgresql.org; Thu, 24 Oct 2019 15:18:07 +0000 Content-Type: multipart/mixed; boundary="===============2986038514294070253==" MIME-Version: 1.0 Subject: Instead of using the bloom index, a parallel sequencial scan is used with this example To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: dwe@dbi-services.com Reply-To: dwe@dbi-services.com, pgsql-docs@lists.postgresql.org Date: Thu, 24 Oct 2019 15:17:06 +0000 Message-ID: <157193022667.1049.11617112818811329354@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============2986038514294070253== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMi9ibG9v bS5odG1sCkRlc2NyaXB0aW9uOgoKcG9zdGdyZXM9IyBDUkVBVEUgVEFCTEUgdGJsb29tIEFTDQpw b3N0Z3Jlcy0jICAgIFNFTEVDVA0KcG9zdGdyZXMtIyAgICAgIChyYW5kb20oKSAqIDEwMDAwMDAp OjppbnQgYXMgaTEsDQpwb3N0Z3Jlcy0jICAgICAgKHJhbmRvbSgpICogMTAwMDAwMCk6OmludCBh cyBpMiwNCnBvc3RncmVzLSMgICAgICAocmFuZG9tKCkgKiAxMDAwMDAwKTo6aW50IGFzIGkzLA0K cG9zdGdyZXMtIyAgICAgIChyYW5kb20oKSAqIDEwMDAwMDApOjppbnQgYXMgaTQsDQpwb3N0Z3Jl cy0jICAgICAgKHJhbmRvbSgpICogMTAwMDAwMCk6OmludCBhcyBpNSwNCnBvc3RncmVzLSMgICAg ICAocmFuZG9tKCkgKiAxMDAwMDAwKTo6aW50IGFzIGk2DQpwb3N0Z3Jlcy0jICAgIEZST00NCnBv c3RncmVzLSMgICBnZW5lcmF0ZV9zZXJpZXMoMSwxMDAwMDAwMCk7DQpTRUxFQ1QgMTAwMDAwMDAN CnBvc3RncmVzPSMgQ1JFQVRFIElOREVYIGJsb29taWR4IE9OIHRibG9vbSBVU0lORyBibG9vbSAo aTEsIGkyLCBpMywgaTQsIGk1LAppNik7DQpFUlJPUjogIGFjY2VzcyBtZXRob2QgImJsb29tIiBk b2VzIG5vdCBleGlzdA0KcG9zdGdyZXM9IyBjcmVhdGUgZXh0ZW5zaW9uIGJsb29tOw0KQ1JFQVRF IEVYVEVOU0lPTg0KcG9zdGdyZXM9IyBDUkVBVEUgSU5ERVggYmxvb21pZHggT04gdGJsb29tIFVT SU5HIGJsb29tIChpMSwgaTIsIGkzLCBpNCwgaTUsCmk2KTsNCkNSRUFURSBJTkRFWA0KcG9zdGdy ZXM9IyBDUkVBVEUgaW5kZXggYnRyZWVpZHggT04gdGJsb29tIChpMSwgaTIsIGkzLCBpNCwgaTUs IGk2KTsNCkNSRUFURSBJTkRFWA0KcG9zdGdyZXM9IyBFWFBMQUlOIEFOQUxZWkUgU0VMRUNUICog RlJPTSB0Ymxvb20gV0hFUkUgaTIgPSA4OTg3MzIgQU5EIGk1ID0KMTIzNDUxOw0KUVVFUlkgUExB Tg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tDQpHYXRoZXIgIChjb3N0PTEwMDAuMDAuLjEyNzIyMC4wMCByb3dzPTI1MCB3 aWR0aD0yNCkgKGFjdHVhbAp0aW1lPTk3NC40NjcuLjk3NC41MTMgcm93cz0wIGxvb3BzPTEpDQpX b3JrZXJzIFBsYW5uZWQ6IDINCldvcmtlcnMgTGF1bmNoZWQ6IDINCi0+ICBQYXJhbGxlbCBTZXEg U2NhbiBvbiB0Ymxvb20gIChjb3N0PTAuMDAuLjEyNjE5NS4wMCByb3dzPTEwNCB3aWR0aD0yNCkK KGFjdHVhbCB0aW1lPTg5NS40NDguLjg5NS40NDggcm93cz0wIGxvb3BzPTMpDQpGaWx0ZXI6ICgo aTIgPSA4OTg3MzIpIEFORCAoaTUgPSAxMjM0NTEpKQ0KUm93cyBSZW1vdmVkIGJ5IEZpbHRlcjog MzMzMzMzMw0KUGxhbm5pbmcgVGltZTogMTYuMDA2IG1zDQpFeGVjdXRpb24gVGltZTogOTc0LjYz NSBtcw0KKDggcm93cykNCg0KcG9zdGdyZXM9IyBhbmFseXplIHRibG9vbTsNCkFOQUxZWkUNCnBv c3RncmVzPSMgRVhQTEFJTiBBTkFMWVpFIFNFTEVDVCAqIEZST00gdGJsb29tIFdIRVJFIGkyID0g ODk4NzMyIEFORCBpNSA9CjEyMzQ1MTsNClFVRVJZIFBMQU4NCi0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCkdhdGhlciAgKGNv c3Q9MTAwMC4wMC4uMTI3MTk1LjgyIHJvd3M9MSB3aWR0aD0yNCkgKGFjdHVhbAp0aW1lPTgwMy4z MTQuLjgwMy40MzYgcm93cz0wIGxvb3BzPTEpDQpXb3JrZXJzIFBsYW5uZWQ6IDINCldvcmtlcnMg TGF1bmNoZWQ6IDINCi0+ICBQYXJhbGxlbCBTZXEgU2NhbiBvbiB0Ymxvb20gIChjb3N0PTAuMDAu LjEyNjE5NS43MiByb3dzPTEgd2lkdGg9MjQpCihhY3R1YWwgdGltZT03NzUuOTExLi43NzUuOTEx IHJvd3M9MCBsb29wcz0zKQ0KRmlsdGVyOiAoKGkyID0gODk4NzMyKSBBTkQgKGk1ID0gMTIzNDUx KSkNClJvd3MgUmVtb3ZlZCBieSBGaWx0ZXI6IDMzMzMzMzMNClBsYW5uaW5nIFRpbWU6IDAuNDE2 IG1zDQpFeGVjdXRpb24gVGltZTogODAzLjQ3MSBtcw0KKDggcm93cykK --===============2986038514294070253==--