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 1reSKO-00BROr-DG for pgsql-hackers@arkaria.postgresql.org; Mon, 26 Feb 2024 04:10:57 +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 1reSKM-00AAWp-Mi for pgsql-hackers@arkaria.postgresql.org; Mon, 26 Feb 2024 04:10:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1reSKM-00AAWh-7a for pgsql-hackers@lists.postgresql.org; Mon, 26 Feb 2024 04:10:54 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1reSKI-0012bu-HW for pgsql-hackers@postgresql.org; Mon, 26 Feb 2024 04:10:53 +0000 Received: from [172.30.8.234] (unknown [172.30.8.234]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) (Authenticated sender: a.rybakina@postgrespro.ru) by mail.postgrespro.ru (Postfix/587) with ESMTPSA id 322D1E20E26; Mon, 26 Feb 2024 07:10:48 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mx2023; t=1708920648; bh=XiviIK5S+kU3Ki1cLEJy98h+mZkylGG6J2alfOLOtuk=; h=Message-ID:Date:User-Agent:Subject:To:Cc:References:From: In-Reply-To:From; b=sNtSUnAUeg50ECFQhiWgrOpumVZsh1mBDADXYqYLXN8hPQVHU4V8Vr2st3P6xEJVA EQH5R/EqlpiMs5iZ+WfYPl94XdV2cSZZPl5qUwIR/jEPdg3pbFhZAQijw4FUilMWDe imgg1aWtKbdg/qG44K66sbozhhyMd5A7bgjB0wcS20pvtqbs3R1j9pjjZyPtMKowIH G0hXq2dFjuYlVH3DkZ3ISOJN+mP4pB0nM7ioR6UU7x94nx0dhih1G8AF6ofZLq9isP s0ICKBkGcqh4jV5ch82R8jovSXJp3sBY7sONBlqs9Mf5xn/tfR1nbe4zzRR4bZtXEq l7Dz50tig/B3A== Content-Type: multipart/mixed; boundary="------------lET3evN0F0Mh10G9Jxs0rQ7X" Message-ID: Date: Mon, 26 Feb 2024 07:10:47 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: POC, WIP: OR-clause support for indexes To: jian he Cc: Andrei Lepikhov , Alexander Korotkov , Robert Haas , pgsql-hackers@postgresql.org, Peter Geoghegan , "Finnerty, Jim" , Marcos Pegoraro , teodor@sigaev.ru, Tomas Vondra , Peter Eisentraut , Ranier Vilela References: <567ED6CA.2040504@sigaev.ru> <7e11e27b-7ab9-4d59-af0a-a921861a9206@postgrespro.ru> <13ad923a-33df-4b44-9e00-c9323cd4c37d@postgrespro.ru> <1cf6b382-6e27-4268-9f2a-54ada66eb2eb@postgrespro.ru> <5f119769-ab11-4807-abcc-71d5dd914ea0@postgrespro.ru> <21088129-7cd3-424a-bcce-6a3427ba3276@postgrespro.ru> Content-Language: en-US From: Alena Rybakina In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------lET3evN0F0Mh10G9Jxs0rQ7X Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 24.02.2024 14:28, jian he wrote: > Hi. > I wrote the first draft patch of the documentation. > it's under the section: Planner Method Configuration (runtime-config-query.html) > but this feature's main meat is in src/backend/parser/parse_expr.c > so it may be slightly inconsistent, as mentioned by others. > > You can further furnish it. Thank you for your work. I found a few spelling mistakes - I fixed this and added some information about generating a partial index plan. I attached it. -- Regards, Alena Rybakina Postgres Professional: http://www.postgrespro.com The Russian Postgres Company --------------lET3evN0F0Mh10G9Jxs0rQ7X Content-Type: text/plain; charset=UTF-8; name="v1-0001-Add-enable_or_transformation-doc-entry.no-cfbot" Content-Disposition: attachment; filename="v1-0001-Add-enable_or_transformation-doc-entry.no-cfbot" Content-Transfer-Encoding: base64 RnJvbSBlM2EwZTAxYzQzYTcwMDk5ZjY4NzBhNDY4ZDBjYzNhOGJkY2IyNzc1IE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBBbGVuYSBSeWJha2luYSA8YS5yeWJha2luYUBwb3N0 Z3Jlc3Byby5ydT4KRGF0ZTogTW9uLCAyNiBGZWIgMjAyNCAwNjozNzozNiArMDMwMApTdWJq ZWN0OiBbUEFUQ0hdIGRvYzEKCi0tLQogZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21sIHwgNzQg KysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKwogMSBmaWxlIGNoYW5n ZWQsIDc0IGluc2VydGlvbnMoKykKCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvY29uZmln LnNnbWwgYi9kb2Mvc3JjL3NnbWwvY29uZmlnLnNnbWwKaW5kZXggMzZhMmE1Y2U0MzEuLjQ3 ZjgyY2EyZGM5IDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvY29uZmlnLnNnbWwKKysrIGIv ZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21sCkBAIC01Mjk0LDYgKzUyOTQsODAgQEAgQU5ZIDxy ZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1ldGVyIj5udW1fc3luYzwvcmVwbGFjZWFibGU+ICgg PHJlcGxhY2VhYmxlIGNsYXNzPSIKICAgICAgIDwvbGlzdGl0ZW0+CiAgICAgIDwvdmFybGlz dGVudHJ5PgogCisgICAgIDx2YXJsaXN0ZW50cnkgaWQ9Imd1Yy1lbmFibGUtb3ItdHJhbnNm b3JtYXRpb24iIHhyZWZsYWJlbD0iZW5hYmxlX29yX3RyYW5zZm9ybWF0aW9uIj4KKyAgICAg IDx0ZXJtPjx2YXJuYW1lPmVuYWJsZV9vcl90cmFuc2Zvcm1hdGlvbjwvdmFybmFtZT4gKDx0 eXBlPmJvb2xlYW48L3R5cGU+KQorICAgICAgIDxpbmRleHRlcm0+CisgICAgICAgIDxwcmlt YXJ5Pjx2YXJuYW1lPmVuYWJsZV9vcl90cmFuc2Zvcm1hdGlvbjwvdmFybmFtZT4gY29uZmln dXJhdGlvbiBwYXJhbWV0ZXI8L3ByaW1hcnk+CisgICAgICAgPC9pbmRleHRlcm0+CisgICAg ICA8L3Rlcm0+CisgICAgICA8bGlzdGl0ZW0+CisgICAgICAgPHBhcmE+CisgICAgICAgIEVu YWJsZXMgb3IgZGlzYWJsZXMgaW4gcXVlcnkgcGxhbm5lcidzIGFiaWxpdHkgdG8gdHJhbnNm b3JtIG11bHRpcGxlIGV4cHJlc3Npb25zIGluICg8eHJlZiBsaW5rZW5kPSJzcWwtZXhwcmVz c2lvbnMiLz4pCisgICAgICAgIDx4cmVmIGxpbmtlbmQ9InNxbC13aGVyZSIvPiB0byBhIEFO WSBleHByZXNzaW9uICg8eHJlZiBsaW5rZW5kPSJmdW5jdGlvbnMtY29tcGFyaXNvbnMtYW55 LXNvbWUiLz4pLgorICAgICAgICBUaGlzIHRyYW5zZm9ybWF0aW9ucyBvbmx5IGFwcGx5IHVu ZGVyIHRoZSBmb2xsb3dpbmcgY29uZGl0aW9uOgorICAgICAgICA8aXRlbWl6ZWRsaXN0Pgor ICAgICAgICAgIDxsaXN0aXRlbT4KKyAgICAgICAgICA8cGFyYT4KKyAgICAgICAgICAgIEVh Y2ggZXhwcmVzc2lvbiBzaG91bGQgYmUgZm9ybWVkIGFzOiA8cmVwbGFjZWFibGU+ZXhwcmVz c2lvbjwvcmVwbGFjZWFibGU+IDxyZXBsYWNlYWJsZT5vcGVyYXRvcjwvcmVwbGFjZWFibGU+ ICAoPHJlcGxhY2VhYmxlPmV4cHJlc3Npb248L3JlcGxhY2VhYmxlPikuCisgICAgICAgICAg ICBUaGUgcmlnaHQtaGFuZCBzaWRlIG9mIHRoZSBvcGVyYXRvciBzaG91bGQgYmUganVzdCBh IHBsYWluIGNvbnN0YW50LgorICAgICAgICAgICAgVGhlIGxlZnQtaGFuZCBzaWRlIG9mIHRo ZXNlIGV4cHJlc3Npb25zIHNob3VsZCByZW1haW4gdW5jaGFuZ2VkLgorICAgICAgICAgIDwv cGFyYT4KKyAgICAgICAgICA8L2xpc3RpdGVtPgorICAgICAgICA8L2l0ZW1pemVkbGlzdD4K KyAgICAgICAgPGl0ZW1pemVkbGlzdD4KKyAgICAgICAgICA8bGlzdGl0ZW0+CisgICAgICAg ICAgPHBhcmE+CisgICAgICAgICAgICBBdCB0aGUgc3RhZ2Ugb2YgaW5kZXggZm9ybWF0aW9u LCBhIGNoZWNrIGlzIG1hZGUgb24gdGhlIHJlc3RydWN0dXJpbmcgb2YgdGhlIHBsYW4gdXNp bmcgcGFydGlhbCBpbmRleGVzIG9yIHRoZSBmb3JtYXRpb24gb2YgZXhwcmVzc2lvbnMgY29t YmluZWQgYnkgdGhlICJPUiIgPHJlcGxhY2VhYmxlPm9wZXJhdG9yPC9yZXBsYWNlYWJsZT4u CisgICAgICAgICAgPC9wYXJhPgorICAgICAgICAgIDwvbGlzdGl0ZW0+CisgICAgICAgIDwv aXRlbWl6ZWRsaXN0PgorICAgICAgICAgICAgPGl0ZW1pemVkbGlzdD4KKyAgICAgICAgICAg ICAgPGxpc3RpdGVtPgorICAgICAgICAgICAgICAgIDxwYXJhPgorICAgICAgICAgICAgICAg ICAgRWFjaCBleHByZXNzaW9uIGZvcm0gc2hvdWxkIHJldHVybiBCb29sZWFuICh0cnVlL2Zh bHNlKSByZXN1bHQuCisgICAgICAgICAgICAgICAgPC9wYXJhPgorICAgICAgICAgICAgICA8 L2xpc3RpdGVtPgorICAgICAgICAgICAgPC9pdGVtaXplZGxpc3Q+CisgICAgICAgICAgICA8 aXRlbWl6ZWRsaXN0PgorICAgICAgICAgICAgICA8bGlzdGl0ZW0+CisgICAgICAgICAgICAg ICAgPHBhcmE+CisgICAgICAgICAgICAgICAgVGhlc2UgZXhwcmVzc2lvbnMgYXJlIGxvZ2lj YWxseSBsaW5rZWQgaW4gYSBPUiBjb25kaXRpb24uCisgICAgICAgICAgICAgICAgPC9wYXJh PgorICAgICAgICAgICAgICA8L2xpc3RpdGVtPgorICAgICAgICAgICAgPC9pdGVtaXplZGxp c3Q+CisgICAgICAgICAgVGhlIGRlZmF1bHQgaXMgPGxpdGVyYWw+b248L2xpdGVyYWw+Lgor ICAgICAgICAgIDwvcGFyYT4KKyAgICAgICAgPHBhcmE+CisgICAgICAgICAgRm9yIGV4YW1w bGUsIHRoZSBmb2xsb3dpbmcgcXVlcnkgd2l0aG91dCBzZXR0aW5nIDx2YXJuYW1lPmVuYWJs ZV9vcl90cmFuc2Zvcm1hdGlvbjwvdmFybmFtZT4gaXMgdXN1YWxseSBhcHBsaWVkIHRvIHRo ZSB0aHJlZSBmaWx0ZXJpbmcgY29uZGl0aW9ucyBzZXBhcmF0ZWx5LAorICAgICAgICAgIGJ1 dCBpZiB3ZSBzZXQgPHZhcm5hbWU+ZW5hYmxlX29yX3RyYW5zZm9ybWF0aW9uPC92YXJuYW1l Piwgd2UgY29tYmluZSB0aGUgdGhyZWUgZXhwcmVzc2lvbnMgaW50byBvbmx5IG9uZSBleHBy ZXNzaW9uOiA8bGl0ZXJhbD51bmlxdWUxID0gQU5ZICgnezEsMiwzfSc6OmludGVnZXJbXSkg PC9saXRlcmFsPi4KKyAgICAgICAgICA8cHJvZ3JhbWxpc3Rpbmc+CisgICAgICAgICAgRVhQ TEFJTiBTRUxFQ1QgKiBGUk9NIHRlbmsxIFdIRVJFIHVuaXF1ZTEgPSAxIG9yIHVuaXF1ZTEg PSAyIG9yIHVuaXF1ZTEgPSAzOworCisgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgUVVFUlkgUExBTgorICAgICAgICAgIC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KKyAgICAgICAgICBTZXEgU2NhbiBv biB0ZW5rMSAgKGNvc3Q9MC4wMC4uNDgyLjUwIHJvd3M9MyB3aWR0aD0yNDQpCisgICAgICAg ICAgICBGaWx0ZXI6ICh1bmlxdWUxID0gQU5ZICgnezEsMiwzfSc6OmludGVnZXJbXSkpCisg ICAgICAgICAgPC9wcm9ncmFtbGlzdGluZz4KKyAgICAgICAgPC9wYXJhPgorICAgICAgICA8 cGFyYT4KKyAgICAgICAgICBBbm90aGVyIGV4YW1wbGUgaXMgdGhlIGZvbGxvd2luZyBxdWVy eSB3aXRoIGEgZ2l2ZW4gPHZhcm5hbWU+ZW5hYmxlX29yX3RyYW5zZm9ybWF0aW9uPC92YXJu YW1lPiB2YWx1ZSwgYnV0IHdlIGhhdmUgZ2VuZXJhdGVkIGEgcGxhbiB3aXRoIHBhcnRpYWwg aW5kZXhlcy4KKyAgICAgICAgICA8cHJvZ3JhbWxpc3Rpbmc+CisgICAgICAgICAgRVhQTEFJ TiBTRUxFQ1QgdW5pcXVlMiwgc3RyaW5ndTEgRlJPTSBvbmVrMiBXSEVSRSB1bmlxdWUxID0g MSBPUiB1bmlxdWUxID0gUEkoKTo6aW50ZWdlcjsKKyAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIFFVRVJZIFBMQU4gICAgICAgICAgICAgICAgICAgIAorICAgICAgICAgIC0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCisgICAgICAg ICAgQml0bWFwIEhlYXAgU2NhbiBvbiBvbmVrMgorICAgICAgICAgICAgUmVjaGVjayBDb25k OiAoKHVuaXF1ZTEgPSAzKSBPUiAodW5pcXVlMSA9IDEpKQorICAgICAgICAgICAgLT4gIEJp dG1hcE9yCisgICAgICAgICAgICAgICAgICAtPiAgQml0bWFwIEluZGV4IFNjYW4gb24gb25l azJfdTFfcHJ0bAorICAgICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKHVuaXF1 ZTEgPSAzKQorICAgICAgICAgICAgICAgICAgLT4gIEJpdG1hcCBJbmRleCBTY2FuIG9uIG9u ZWsyX3UxX3BydGwKKyAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6ICh1bmlx dWUxID0gMSkKKyAgICAgICAgICAoNyByb3dzKQorICAgICAgICAgIDwvcHJvZ3JhbWxpc3Rp bmc+CisgICAgICAgIDwvcGFyYT4KKyAgICAgIDwvbGlzdGl0ZW0+CisgICAgIDwvdmFybGlz dGVudHJ5PgorCiAgICAgIDx2YXJsaXN0ZW50cnkgaWQ9Imd1Yy1lbmFibGUtcGFyYWxsZWwt YXBwZW5kIiB4cmVmbGFiZWw9ImVuYWJsZV9wYXJhbGxlbF9hcHBlbmQiPgogICAgICAgPHRl cm0+PHZhcm5hbWU+ZW5hYmxlX3BhcmFsbGVsX2FwcGVuZDwvdmFybmFtZT4gKDx0eXBlPmJv b2xlYW48L3R5cGU+KQogICAgICAgPGluZGV4dGVybT4KLS0gCjIuMzQuMQoK --------------lET3evN0F0Mh10G9Jxs0rQ7X--