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 1sJXiL-005SZz-Hz for pgsql-hackers@arkaria.postgresql.org; Tue, 18 Jun 2024 12:13:29 +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 1sJXiJ-00CF8s-6K for pgsql-hackers@arkaria.postgresql.org; Tue, 18 Jun 2024 12:13:28 +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 1sJXiI-00CF8k-Sr for pgsql-hackers@lists.postgresql.org; Tue, 18 Jun 2024 12:13:27 +0000 Received: from mail-yb1-xb2d.google.com ([2607:f8b0:4864:20::b2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sJXiH-002HWd-1l for pgsql-hackers@postgresql.org; Tue, 18 Jun 2024 12:13:27 +0000 Received: by mail-yb1-xb2d.google.com with SMTP id 3f1490d57ef6-e02b605bca2so271070276.1 for ; Tue, 18 Jun 2024 05:13:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1718712803; x=1719317603; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=RzuO1rgVoQmgVBFxVVcaIZzw9JiBLy0Tj29DO8Uel4s=; b=AvhAMix/z0fiApdKI1y2/1NZAPOiboQeSWqeGGih9S/AMga5OIIFuN/K2YHS8+ZhS8 ZiZSPE/ePMWKfsIs8xLhC1syY0Pa81tfrlsQ73eFsSFGs50UcR87SKwttVUAsDfCAbZc kLTeJKEpdYO79NAcyUgg09BtQG2s1tFRkvijAmB0V8X8WjQMSulYsUiaoV7gslepC9xC sb2OwKp//WVGQqWpJ9AROMDea+UErsWncfVIPQOfx6NKucKTbvxAoIgn4V+Ftzn3oR9j KrQogeSBcENupUccMEIp+uaHvq9F59dijtESX5j3ypBidgN52mWiEjW6TJMZAzBHG4Ur yO0Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1718712803; x=1719317603; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=RzuO1rgVoQmgVBFxVVcaIZzw9JiBLy0Tj29DO8Uel4s=; b=KFTcrJaL/G4gYN7pXZUYi+QbV8Ht6dycBCjZfoVMY9caP9BOLDopFYmHvpQJt2CPy4 jReWg0gLq0lvYvp916PD9LqyAAF8jyJHvVp8gMs6RGMX6zHed9aSno5T7KODGNUqIR+0 NfnWdNJoc7mpsn+8XmTlY9QJOtMuMJUE1N0o/ytvL+0WmhDkTgGZVbRk0BbdAj+yeh4E ZrDDwAh3Wlei5V1PYLJWxf2rdfLgxvQDa0g9kmhQ/aQWbHQQ9zj/JD1zdl0nJg+ZAjXG Q5jze67ZVT2/flKEeeaVwqjMX1hpmA/2dx654XKEypIVAMSEogIosDOaniqwFgiWslGr rlxA== X-Forwarded-Encrypted: i=1; AJvYcCV1Hk8kYwNeEeScauWs6aP/dYWWaM5RMTy+GDFN7HmobpKCimnU77UQ8aN0Mh0/Y8IPa4AnmXQovBEpyMGgGeYTK77yKLSPX8Kz1SRr X-Gm-Message-State: AOJu0YzicvnumM+NbPuwIldPZ7SK61x+7sV3xFohgN2HQxVprymH05Iv +6b8hBuOIlr5PeW+LxSDk2vyJAJJc+QC6liK2W9fIbppg02l3K72nE9xwmiprv4cktZ9wfaZZPA ZT2d7HBlVfy4m9nxWKnVtJ+FLzC0= X-Google-Smtp-Source: AGHT+IHKbhjlg83GVPYLIsMEvVsxPWpFHMl6H59a2e3Fzn5X5SRViolDugfYMZxMYFln3NJCV0U132P/+KUOs5c5qGg= X-Received: by 2002:a25:6843:0:b0:dff:2f30:1f2e with SMTP id 3f1490d57ef6-e022275974dmr1405984276.12.1718712803417; Tue, 18 Jun 2024 05:13:23 -0700 (PDT) MIME-Version: 1.0 References: <0a352a79-efaf-4e2f-884c-0630e57c6980@gmail.com> In-Reply-To: <0a352a79-efaf-4e2f-884c-0630e57c6980@gmail.com> From: Alexander Korotkov Date: Tue, 18 Jun 2024 15:13:11 +0300 Message-ID: Subject: Re: Missing docs for new enable_group_by_reordering GUC To: Andrei Lepikhov Cc: Bruce Momjian , PostgreSQL-development Content-Type: multipart/mixed; boundary="0000000000001ead07061b2902b9" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000001ead07061b2902b9 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Jun 18, 2024 at 9:14=E2=80=AFAM Andrei Lepikhov = wrote: > On 6/18/24 09:32, Bruce Momjian wrote: > > This commit added enable_group_by_reordering: > > > > commit 0452b461bc4 > > Author: Alexander Korotkov > > Date: Sun Jan 21 22:21:36 2024 +0200 > > It mentions it was added as a GUC to postgresql.conf, but I see no SGML > > docs for this new GUC value. Would someone please add docs for this? > > Thanks. > It is my mistake, sorry for that. See the patch in attachment. Bruce, thank for noticing. Andrei, thank you for providing a fix. Please, check the revised patch. ------ Regards, Alexander Korotkov Supabase --0000000000001ead07061b2902b9 Content-Type: application/octet-stream; name="v2-0001-Add-doc-entry-for-the-new-GUC-paramenter-enable_g.patch" Content-Disposition: attachment; filename="v2-0001-Add-doc-entry-for-the-new-GUC-paramenter-enable_g.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_lxkd7m4r0 RnJvbSBmNDQ0MzZiOWViZDNmNjNjZGQ0ZDFkM2UxYjQ2YThmNjYwZTVlZGFjIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBBbGV4YW5kZXIgS29yb3Rrb3YgPGFrb3JvdGtvdkBwb3N0Z3Jl c3FsLm9yZz4KRGF0ZTogVHVlLCAxOCBKdW4gMjAyNCAxNTowODoxNyArMDMwMApTdWJqZWN0OiBb UEFUQ0ggdjJdIEFkZCBkb2MgZW50cnkgZm9yIHRoZSBuZXcgR1VDIHBhcmFtZW50ZXIKIGVuYWJs ZV9ncm91cF9ieV9yZW9yZGVyaW5nCgowNDUyYjQ2MWJjNCBhZGRzIGFsdGVybmF0aXZlIG9yZGVy aW5ncyBvZiBncm91cC1ieSBrZXlzIGR1cmluZyB0aGUgcXVlcnkKb3B0aW1pemF0aW9uLiBUaGlz IG5ldyBmZWF0dXJlIGlzIGNvbnRyb2xsZWQgYnkgdGhlIG5ldyBHVUMgcGFyYW1ldGVyCmVuYWJs ZV9ncm91cF9ieV9yZW9yZGVyaW5nLCB3aGljaCBhY2NpZGVudGFsbHkgY2FtZSB3aXRob3V0IHRo ZSBkb2N1bWVudGF0aW9uLgpUaGlzIGNvbW1pdCBhZGRzIHRoZSBtaXNzaW5nIGRvY3VtZW50YXRp b24gZm9yIHRoYXQgR1VDLgoKUmVwb3J0ZWQtYnk6IEJydWNlIE1vbWppYW4KRGlzY3Vzc2lvbjog aHR0cHM6Ly9wb3N0Z3IuZXMvbS9abkR4MkZZbGJhX09hZlFkJTQwbW9tamlhbi51cwpBdXRob3I6 IEFuZHJlaSBMZXBpa2hvdgotLS0KIGRvYy9zcmMvc2dtbC9jb25maWcuc2dtbCB8IDE4ICsrKysr KysrKysrKysrKysrKwogMSBmaWxlIGNoYW5nZWQsIDE4IGluc2VydGlvbnMoKykKCmRpZmYgLS1n aXQgYS9kb2Mvc3JjL3NnbWwvY29uZmlnLnNnbWwgYi9kb2Mvc3JjL3NnbWwvY29uZmlnLnNnbWwK aW5kZXggNjk4MTY5YWZkYjYuLmQ0NWNiMDJhZDE1IDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwv Y29uZmlnLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21sCkBAIC01MzI3LDYgKzUz MjcsMjQgQEAgQU5ZIDxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1ldGVyIj5udW1fc3luYzwvcmVw bGFjZWFibGU+ICggPHJlcGxhY2VhYmxlIGNsYXNzPSIKICAgICAgIDwvbGlzdGl0ZW0+CiAgICAg IDwvdmFybGlzdGVudHJ5PgogCisgICAgIDx2YXJsaXN0ZW50cnkgaWQ9Imd1Yy1lbmFibGUtZ3Jv dXBieS1yZW9yZGVyaW5nIiB4cmVmbGFiZWw9ImVuYWJsZV9ncm91cF9ieV9yZW9yZGVyaW5nIj4K KyAgICAgIDx0ZXJtPjx2YXJuYW1lPmVuYWJsZV9ncm91cF9ieV9yZW9yZGVyaW5nPC92YXJuYW1l PiAoPHR5cGU+Ym9vbGVhbjwvdHlwZT4pCisgICAgICA8aW5kZXh0ZXJtPgorICAgICAgIDxwcmlt YXJ5Pjx2YXJuYW1lPmVuYWJsZV9ncm91cF9ieV9yZW9yZGVyaW5nPC92YXJuYW1lPiBjb25maWd1 cmF0aW9uIHBhcmFtZXRlcjwvcHJpbWFyeT4KKyAgICAgIDwvaW5kZXh0ZXJtPgorICAgICAgPC90 ZXJtPgorICAgICAgPGxpc3RpdGVtPgorICAgICAgIDxwYXJhPgorICAgICAgICBFbmFibGVzIG9y IGRpc2FibGVzIHRoZSByZW9yZGVyaW5nIG9mIGtleXMgaW4gYQorICAgICAgICA8bGl0ZXJhbD5H Uk9VUCBCWTwvbGl0ZXJhbD4gY2xhdXNlIHRvIG1hdGNoIHRoZSBvcmRlcmluZyBrZXlzIG9mIGEK KyAgICAgICAgY2hpbGQgbm9kZSBvZiB0aGUgcGxhbiwgc3VjaCBhcyBhbiBpbmRleCBzY2FuLiBX aGVuIHR1cm5lZCBvZmYsIGtleXMKKyAgICAgICAgaW4gYSA8bGl0ZXJhbD5HUk9VUCBCWTwvbGl0 ZXJhbD4gY2xhdXNlIGFyZSBvbmx5IHJlb3JkZXJlZCB0byBtYXRjaAorICAgICAgICB0aGUgPGxp dGVyYWw+T1JERVIgQlk8L2xpdGVyYWw+IGNsYXVzZSwgaWYgYW55LiBUaGUgZGVmYXVsdCBpcwor ICAgICAgICA8bGl0ZXJhbD5vbjwvbGl0ZXJhbD4uCisgICAgICAgPC9wYXJhPgorICAgICAgPC9s aXN0aXRlbT4KKyAgICAgPC92YXJsaXN0ZW50cnk+CisKICAgICAgPHZhcmxpc3RlbnRyeSBpZD0i Z3VjLWVuYWJsZS1nYXRoZXJtZXJnZSIgeHJlZmxhYmVsPSJlbmFibGVfZ2F0aGVybWVyZ2UiPgog ICAgICAgPHRlcm0+PHZhcm5hbWU+ZW5hYmxlX2dhdGhlcm1lcmdlPC92YXJuYW1lPiAoPHR5cGU+ Ym9vbGVhbjwvdHlwZT4pCiAgICAgICA8aW5kZXh0ZXJtPgotLSAKMi4zOS4zIChBcHBsZSBHaXQt MTQ1KQoK --0000000000001ead07061b2902b9--