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 1t5LqO-005WpZ-0v for pgsql-hackers@arkaria.postgresql.org; Mon, 28 Oct 2024 09:15:24 +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 1t5LqK-0054gZ-MK for pgsql-hackers@arkaria.postgresql.org; Mon, 28 Oct 2024 09:15:21 +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 1t5LqK-0054gR-CQ for pgsql-hackers@lists.postgresql.org; Mon, 28 Oct 2024 09:15:20 +0000 Received: from mail-pj1-x102a.google.com ([2607:f8b0:4864:20::102a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t5LqE-003FRn-Cm for pgsql-hackers@postgresql.org; Mon, 28 Oct 2024 09:15:19 +0000 Received: by mail-pj1-x102a.google.com with SMTP id 98e67ed59e1d1-2e2ed59a35eso3317212a91.0 for ; Mon, 28 Oct 2024 02:15:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1730106913; x=1730711713; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=fBh19mBXRnkV+a8tXwlUdv3Va9o2LynhBvkQu2XRmlo=; b=QJsftLXqY7baoKE+SuU6rqqmkvt2obYvjSxsO8SjWyjo5E8vOS/1dgw0v499vkSfxK /7+OSWlz0mrLPXPtN/9WWy0OcVuqkKcQquGvxxnJ6XR75/6nnNaXxCOAzxIVSzr0Soig XD1DsjD9NzlxGK+D/hSxGb/TvB+gpoHXtt2mDEWJdbnoH1am3iAb8S2i7XSkYYOZr5L2 GJUFAUvKY0pDMC5v4qUPQ9KC14tiLfOVkTZalhrke+Z93NmZEXReWlyDWdpHKDNMKVxg JKmMpZxLsHUj6BSdBoVmPsaQX3apnjRDmD2KvBH99zp91MPEETA1rH58NDUfVcsr75Z5 P8Mg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1730106913; x=1730711713; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=fBh19mBXRnkV+a8tXwlUdv3Va9o2LynhBvkQu2XRmlo=; b=UZidKdZ7+8HeXe61px+Q0NwTGpjHURnRLxFk3TLCZxmJgCK8jGZwgaoK2PSVpPFKCH jl8iGAgFd5Myu7M3F5irP6rwZ/YOmd+Eo+9zAIiBDLuAg2K5Aap43R9p46hbQdaDMuhN 2F9I9fDRXOmrN7FNWSMjb33Um5TtYzCfnK29ygcNj9fMLy5FIlP5R8t6a5M3jsvRBWCY vo8knNO8sVpJ54s1+lqRpHXK0ppDy14CHASG+8imaSWx1uFUh8W0PnVdK2EVNKbt/osv 9d2roFzli59hx7jnQRJjNyrhJ3jg3Km46tGVZ+jpY/C3KpQrrlfMUhhxtFBkan5shyY7 95/Q== X-Gm-Message-State: AOJu0YzGWz9rH+eAVAJLct4TbhUuXdQI0+SNs8AC4adgxyXbacXfmgcz RpYX6nFzY20Ra9BpVBd5m2nEkKSD7p2RkMKF0kV1fMm6ynKsoe0h X-Google-Smtp-Source: AGHT+IHeQvh1Dk2nTF01AaC5UV5+5SXPfpbqu7lnZJ/3f+tz7xzeL9w1TuYGJSh9ODrI6rniPlno1g== X-Received: by 2002:a17:90a:2c0e:b0:2e2:8472:c350 with SMTP id 98e67ed59e1d1-2e8f1072989mr8553672a91.17.1730106913358; Mon, 28 Oct 2024 02:15:13 -0700 (PDT) Received: from [10.10.20.104] (node-qog.pool-125-24.dynamic.totinternet.net. [125.24.135.16]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-2e8e3771814sm6625852a91.52.2024.10.28.02.15.11 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 28 Oct 2024 02:15:12 -0700 (PDT) Message-ID: <0fc11a92-f6e4-4d8c-b882-91283ef54bce@gmail.com> Date: Mon, 28 Oct 2024 16:15:09 +0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Reordering DISTINCT keys to match input path's pathkeys To: Richard Guo Cc: PostgreSQL-development , David Rowley References: Content-Language: en-AU From: Andrei Lepikhov In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 6/7/24 16:46, Richard Guo wrote: > On Mon, Feb 5, 2024 at 11:18 AM Richard Guo wrote: >> cfbot reminds that this patch does not apply any more. So I've rebased >> it on master, and also adjusted the test cases a bit. > > This patch does not apply any more, so here is a new rebase, with some > tweaks to the comments. This patch needs a minor rebase again. After skimming the code, I want to say that it looks good. But maybe to avoid one more *_reordering GUC - it would be better to cover all path key reorderings under a single GUC. -- regards, Andrei Lepikhov