Postgres Pro
Downloads
Home   >   mailing lists

Re: Reordering DISTINCT keys to match input path's pathkeys - Mailing list pgsql-hackers

From Andrei Lepikhov
Subject Re: Reordering DISTINCT keys to match input path's pathkeys
Date
Msg-id cea712ca-d5db-432e-9170-bcb1ed3b95ee@gmail.com
Whole thread Raw
In response to Reordering DISTINCT keys to match input path's pathkeys  (Richard Guo <guofenglinux@gmail.com>)
List pgsql-hackers
Tree view 
On 11/13/24 13:49, Richard Guo wrote:
> On Mon, Oct 28, 2024 at 6:15 PM Andrei Lepikhov <lepihov@gmail.com> wrote:
>> On 6/7/24 16:46, Richard Guo wrote:
> I'm not sure about merging these two 'reordering' GUCs into one.
> While they may look similar, they apply to very different scenarios.
> However, I'm open to other suggestions.
I finally have passed through the code. It generally looks OK. Let me 
only write a few words on tests.
I wonder if it would be possible to print only three rows instead of 10 
to prove the DISTINCT's correctness.
Also, to stabilise tests with parallel workers, I would recommend 
setting max_parallel_workers_per_gather into 1 and enabling 
debug_parallel_query.

-- 
regards, Andrei Lepikhov

pgsql-hackers by date:

Previous
From: Erik Nordström
Date:
Subject: Re: Changed behavior in rewriteheap
Next
From: Masahiro Ikeda
Date:
Subject: Re: Adding skip scan (including MDAM style range skip scan) to nbtree