Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uUOaY-002bML-E4 for pgsql-bugs@arkaria.postgresql.org; Wed, 25 Jun 2025 11:46:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uUOaW-002nHv-G6 for pgsql-bugs@arkaria.postgresql.org; Wed, 25 Jun 2025 11:46:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uUCda-00Fjc2-I3 for pgsql-bugs@lists.postgresql.org; Tue, 24 Jun 2025 23:01:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uUCdV-003oHW-1p for pgsql-bugs@lists.postgresql.org; Tue, 24 Jun 2025 23:01:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=UGZAC0PrOPgpzf4zHvbSEKf2VbKbat94LGUur+WNRYE=; b=WUv+xkxVRkWt+yQw3WK743qPHI nzBMvV+q909d2mvM0S2jNfOgvCPcewKQDirTYVpOfT2ji5zzyKRHLBIDOiTNy0JnJDsXmdRlJzo9n o7XH83bGeaGP+fa76Gb5amdpBhCV1D4gwlmcwsFp+cnBjY6JedQyvrRux/IZ6jBweQdERH4x4VrVQ K87oBgriFCwRAvem3CjrDHbtF2q+U3dVijt3wjzOe1xEVsd2HEnyYdy3ZRMJuTS4BBuUZIMXeGGCQ AfhR5NNkRZKwn5DfK/92wuJTOj8qCGfY0hUKwj83N6BeFzusN/KdY8UNhOdbzuwfN3YicEXZoAnXG /BnFZfew==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uUCdU-00Amy4-SM for pgsql-bugs@lists.postgresql.org; Tue, 24 Jun 2025 23:01:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uUCdT-006A59-0W for pgsql-bugs@lists.postgresql.org; Tue, 24 Jun 2025 23:01:03 +0000 Content-Type: multipart/mixed; boundary="===============7557537101290489433==" MIME-Version: 1.0 Subject: BUG #18968: GiST Index Cost Estimation To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: victorq@extrahop.com Reply-To: victorq@extrahop.com, pgsql-bugs@lists.postgresql.org Date: Tue, 24 Jun 2025 23:00:41 +0000 Message-ID: <18968-eb7187b33887f562@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7557537101290489433== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODk2OApMb2dnZWQgYnk6ICAgICAgICAgIFZpY3RvciBRdWFydHVjaW8K RW1haWwgYWRkcmVzczogICAgICB2aWN0b3JxQGV4dHJhaG9wLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDE3LjUKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjIuMDQKRGVzY3JpcHRpb246ICAg ICAgICAKCldoZW4gYSB0ZXh0IGNvbHVtbiBoYXMgYm90aCBhIEItdHJlZSB1bmlxdWUgaW5kZXgg YW5kIGEgR2lTVCBnaXN0X3RyZ21fb3BzCmluZGV4LCBzb21ldGltZXMgdGhlIHBsYW5uZXIgZXN0 aW1hdGVzIGEgc2xpZ2h0bHkgbG93ZXIgY29zdCB0byB1c2UgdGhlIEdpU1QKaW5kZXggZm9yIGFu IElOL0FOWSBxdWVyeSB3aXRoIGEgY29uc3RhbnQgbGlzdCwgYnV0IHRoZSBhY3R1YWwgY29zdCB0 byB1c2UKdGhlIEdpU1QgaW5kZXggaXMgb3JkZXJzIG9mIG1hZ25pdHVkZSBoaWdoZXIgdGhhbiB0 aGUgQi10cmVlIGluZGV4LCBlLmcuIDIKbWluIHZlcnN1cyA2IG1zIGluIHRoZSBleGFtcGxlIGJl bG93LiBJcyB0aGUgR2lTVCBpbmRleCBjb3N0IGVzdGltYXRlIHRvbwpsb3cgZm9yIGdpc3RfdHJn bV9vcHM/IFRoaXMgc2VlbXMgc2ltaWxhciB0byBhIHJlbGF0aXZlbHkgcmVjZW50IGRpc2N1c3Np b24KKDIwMjIpIHJlZ2FyZGluZyBHaU4sIEdpU1QgaW5kZXggY29zdCAodmVyc3VzIEItVHJlZSkg dGhhdCBsZWQgdG8gYSBwYXRjaApodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlk L2ZsYXQvMzE4ODYxNy40NGNzUHpMMzlaJTQwYWl2ZW5yb25hbiAuCkZ1cnRoZXIgb2JzZXJ2YXRp b25zOgpJIGhhdmUgZXhwZXJpbWVudGVkIHdpdGggdmFyaW91cyBzZXR0aW5ncyBhcyBzdWdnZXN0 ZWQgd2l0aCBzb21lIHN1Y2Nlc3MuClRoZSBwYXJhbWV0ZXJzIEkgZXhwZXJpbWVudGVkIHdpdGgg aW5jbHVkZSBzZXFfcGFnZV9jb3N0LCByYW5kb21fcGFnZV9jb3N0LAplZmZlY3RpdmVfY2FjaGVf c2l6ZSwgd29ya19tZW0sIGVmZmVjdGl2ZV9pb19jb25jdXJyZW5jeSwKY3B1X2luZGV4X3R1cGxl X2Nvc3QsIGRlZmF1bHRfc3RhdGlzdGljc190YXJnZXQuICBUaGUgb25seSBjaGFuZ2UgdGhhdApw cm9kdWNlZCBhIEItdHJlZSBwbGFuIHdhcyBpbmNyZWFzaW5nIHNlcV9wYWdlX2Nvc3QgdG8gNC4w IHdoaWxlIGxlYXZpbmcKb3RoZXIgc2V0dGluZ3MgYXQgZGVmYXVsdHMuIEJ1dCBhIGhpZ2ggc2Vx X3BhZ2VfY29zdCByZWxhdGl2ZSB0byBkZWZhdWx0CnJhbmRvbV9wYWdlX2Nvc3QvY3B1IGNvc3Rz IGRvZXNu4oCZdCByZWFsbHkgbWFrZSBzZW5zZSBhbmQgaXMgbm90IHJlY29tbWVuZGVkCmZvciBo ZWF2aWx5LWNhY2hlZCBJL08gcGVyZm9ybWFudCBzeXN0ZW1zIChwZXIgdGhlIGRvY3MpLgpBcyB0 aGUgbnVtYmVyIG9mIGVsZW1lbnRzIGluIHRoZSBJTiBpbmNyZWFzZXMsIHRoZSBwZXJmb3JtYW5j ZSBkZWx0YSBnZXRzCndvcnNlLiBJbnRlcmVzdGluZ2x5LCB0aGUgQi1UcmVlIGVzdGltYXRlZCBj b3N0IGdldHMgcHJvZ3Jlc3NpdmVseSBtb3JlCmV4cGVuc2l2ZSB3aGVuIGNvbXBhcmVkIHRvIEdp U1QgZnJvbSAxMDAgLT4gfjYwMCBpdGVtcy4gQnV0LCBhZnRlciAxMDAwCml0ZW1zLCB0aGUgQi1U cmVlIGlzIGNob3Nlbi4KIElOIGVsdHMgIEdpU1QgY29zdCAgYnRyZWUgY29zdCAgY29zdCBkZWx0 YSAgR2lTVCBhY3R1YWwgbXMgIGJ0cmVlIGFjdHVhbCBtcwogICAgIDEwMCAgICAgIDgxNC41ICAg ICAgIDgyOC41ICAgICAgICAxNC4wICAgICAgICAgMjA2MzIuMiAgICAgICAgICAgICAgMS4yCiAg ICAgMzAwICAgICAyMzY2LjYgICAgICAyMzkyLjYgICAgICAgIDI2LjAgICAgICAgICA2MDYwOC43 ICAgICAgICAgICAgICAzLjIKICAgICA2MDAgICAgIDQ1NzQuOSAgICAgIDQ2MDYuOSAgICAgICAg MzIuMCAgICAgICAgMTIxNTk4LjMgICAgICAgICAgICAgIDYuMgogICAgIDgwMCAgICAgNTk5Mi43 ICAgICAgNjAwOC43ICAgICAgICAxNi4wICAgICAgICAxNjEyNjcuMiAgICAgICAgICAgICAgNy44 CiAgICAgOTUwICAgICA3MDIzLjggICAgICA3MDI0LjggICAgICAgICAxLjAgICAgICAgIDE5MDM2 Ni41ICAgICAgICAgICAgICA5LjEKICAgIDEwMDAgICAgIDczNjguNiAgICAgIDczNjAuMyAgICAg ICAgLTguMyAgICAgICAgMjAxOTkzLjcgICAgICAgICAgICAgIDguMgpBbHNvIGludGVyZXN0aW5n bHksIGRlY3JlYXNpbmcgYm90aCByYW5kb21fcGFnZV9jb3N0LCBhbmQgc2VxX3BhZ2VfY29zdCB0 bwowLjksIHRoZSBCLXRyZWUgcGxhbiBpcyBub3QgY2hvc2VuIHVudGlsIH4zNjAwIGl0ZW1zLgpU aGFuayB5b3UuCkNSRUFURSBFWFRFTlNJT04gSUYgTk9UIEVYSVNUUyBwZ190cmdtOwpEUk9QIFRB QkxFIElGIEVYSVNUUyB0MTsKQ1JFQVRFIFRBQkxFIHQxICgKICAgIGlkIFNFUklBTCBQUklNQVJZ IEtFWSwKICAgIG5hbWUgVEVYVCBOT1QgTlVMTAopOwogLS0gSW5zZXJ0IDYwMGsgcmFuZG9tIHN0 cmluZ3MgKH40MC0xNjAgY2hhcnMgbG9uZykgaW50byB0MQpJTlNFUlQgSU5UTyB0MSAobmFtZSkK U0VMRUNUCiAgICAoCiAgICAgICAgU0VMRUNUIHN0cmluZ19hZ2coCiAgICAgICAgICAgIHN1YnN0 cignYWJjZGVmZ2hpamtsbW5vcHFyc3R1dnd4eXonLCBmbG9vcihyYW5kb20oKSAqIDI2ICsKMSk6 OmludCwgMSksCiAgICAgICAgICAgICcnCiAgICAgICAgKQogICAgICAgIEZST00gZ2VuZXJhdGVf c2VyaWVzKDEsIGZsb29yKHJhbmRvbSgpICogKDE2MCAtIDQwICsgMSkgKyA0MCk6OmludCArCihz LmkgKiAwKSkKICAgICkgfHwgJy0nIHx8IHMuaTo6dGV4dApGUk9NCiAgICBnZW5lcmF0ZV9zZXJp ZXMoMSwgNjAwMDAwKSBBUyBzKGkpOwotLSBnaXN0CkNSRUFURSBJTkRFWCB0MV9uYW1lX2dpc3Qg T04gdDEgVVNJTkcgZ2lzdCAobmFtZSBnaXN0X3RyZ21fb3BzKTsKLS0gYi10cmVlCkFMVEVSIFRB QkxFIHQxIEFERCBDT05TVFJBSU5UIHQxX25hbWVfa2V5IFVOSVFVRSAobmFtZSk7CkFOQUxZWkUg dDE7Ci0tIGhpZGUgb3V0cHV0ClxvIC9kZXYvbnVsbAotLSBnZXQgNjAwIG5hbWVzIHRvIHF1ZXJ5 IGFzIGEgbGlzdCBvZiB0ZXh0IGxpdGVyYWxzClNFTEVDVCBzdHJpbmdfYWdnKGZvcm1hdCgnJUwn LCBuYW1lKSwgJywgJykgQVMgbmFtZXNfdG9fZmluZF9saXRlcmFsCkZST00gKFNFTEVDVCBuYW1l IEZST00gdDEgT1JERVIgQlkgcmFuZG9tKCkgTElNSVQgNjAwKTsKXGdzZXQKXG8KXGVjaG8gJ1Bs YW4gd2hlbiBib3RoIEdpU1QgYW5kIEItVHJlZSBpbmRleGVzIGFyZSBhdmFpbGFibGUnCkVYUExB SU4gKEFOQUxZWkUsIEJVRkZFUlMsIFNFVFRJTkdTKQpTRUxFQ1QgKiBGUk9NIHQxCldIRVJFIG5h bWUgSU4gKDpuYW1lc190b19maW5kX2xpdGVyYWwpOwogICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTgotLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tCkJpdG1hcCBIZWFwIFNjYW4gb24gdDEgIChjb3N0PTI2NDAuMTUuLjQ1NzQuOTIgcm93cz02 MDAgd2lkdGg9MTEyKSAoYWN0dWFsCnRpbWU9MTIxNTk1LjQwOC4uMTIxNTk4LjI3MyByb3dzPTYw MCBsb29wcz0xKQogICBSZWNoZWNrIENvbmQ6IChuYW1lID0gQU5ZICgne29taXR0ZWRfZm9yX2Jy ZXZpdHl9Jzo6dGV4dFtdKSkKICAgSGVhcCBCbG9ja3M6IGV4YWN0PTU4OAogICBCdWZmZXJzOiBz aGFyZWQgaGl0PTE3ODI5MDUgcmVhZD0yNzE4Mjk2MSB3cml0dGVuPTIyMDc5CiAgIC0+ICBCaXRt YXAgSW5kZXggU2NhbiBvbiB0MV9uYW1lX2dpc3QgIChjb3N0PTAuMDAuLjI2MzguNTAgcm93cz02 MDAKd2lkdGg9MCkgKGFjdHVhbCB0aW1lPTEyMTU5NS4yNjYuLjEyMTU5NS4yNjcgcm93cz02MDAg bG9vcHM9MSkKICAgICAgICAgSW5kZXggQ29uZDogKG5hbWUgPSBBTlkgKCd7b21pdHRlZF9mb3Jf YnJldml0eX0nOjp0ZXh0W10pKQogICAgICAgICBCdWZmZXJzOiBzaGFyZWQgaGl0PTE3ODI5MDUg cmVhZD0yNzE4MjM3MyB3cml0dGVuPTIyMDc5CiBQbGFubmluZzoKICAgQnVmZmVyczogc2hhcmVk IGhpdD0xMCByZWFkPTEKIFBsYW5uaW5nIFRpbWU6IDAuMzcwIG1zCiBFeGVjdXRpb24gVGltZTog MTIxNTk4LjM0MSBtcwooMTEgcm93cykKXGVjaG8gJ1BsYW4gd2hlbiBvbmx5IEItVHJlZSBpcyBh dmFpbGFibGUnCkRST1AgSU5ERVggdDFfbmFtZV9naXN0OwpFWFBMQUlOIChBTkFMWVpFLCBCVUZG RVJTLCBTRVRUSU5HUykKU0VMRUNUICogRlJPTSB0MQpXSEVSRSBuYW1lIElOICg6bmFtZXNfdG9f ZmluZF9saXRlcmFsKTsKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIFFVRVJZIFBMQU4KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQpCaXRtYXAgSGVhcCBT Y2FuIG9uIHQxICAoY29zdD0yNjcyLjE1Li40NjA2LjkyIHJvd3M9NjAwIHdpZHRoPTExMikgKGFj dHVhbAp0aW1lPTUuNzIyLi42LjE5MiByb3dzPTYwMCBsb29wcz0xKQogICBSZWNoZWNrIENvbmQ6 IChuYW1lID0gQU5ZICgne29taXR0ZWRfZm9yX2JyZXZpdHl9Jzo6dGV4dFtdKSkKICAgSGVhcCBC bG9ja3M6IGV4YWN0PTU4OAogICBCdWZmZXJzOiBzaGFyZWQgaGl0PTIxMDkgcmVhZD04MDcKICAg LT4gIEJpdG1hcCBJbmRleCBTY2FuIG9uIHQxX25hbWVfa2V5ICAoY29zdD0wLjAwLi4yNjcwLjUw IHJvd3M9NjAwCndpZHRoPTApIChhY3R1YWwgdGltZT01LjY1MS4uNS42NTEgcm93cz02MDAgbG9v cHM9MSkKICAgICAgICAgSW5kZXggQ29uZDogKG5hbWUgPSBBTlkgKCd7b21pdHRlZF9mb3JfYnJl dml0eX0nOjp0ZXh0W10pKQogICAgICAgICBCdWZmZXJzOiBzaGFyZWQgaGl0PTE1MjEgcmVhZD04 MDcKIFBsYW5uaW5nOgogICBCdWZmZXJzOiBzaGFyZWQgaGl0PTMgcmVhZD0yIGRpcnRpZWQ9MQog UGxhbm5pbmcgVGltZTogMC4zOTYgbXMKIEV4ZWN1dGlvbiBUaW1lOiA2LjIyOSBtcwooMTEgcm93 cykKCg== --===============7557537101290489433==--