public inbox for [email protected]
help / color / mirror / Atom feedFrom: David Rowley <[email protected]>
To: Tom Lane <[email protected]>
Cc: ma lz <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Why not do distinct before SetOp
Date: Wed, 6 Nov 2024 12:38:00 +1300
Message-ID: <CAApHDvrXUuhGJ_rzsuLY3f1mou1w5RT4zxEb45gbBR3ap6vy4g@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <TYCPR01MB63514B9C70EF2A80F0D43394F2512@TYCPR01MB6351.jpnprd01.prod.outlook.com>
<CAApHDvqdDwEXxhZLTwsHkWnvpvVSYT2OXSzfxRrs2p5xudr9fw@mail.gmail.com>
<[email protected]>
<CAApHDvod=mg8xKbBTFTu7HPWzLk+UhHVdXXwQEj9eNh5buVaiQ@mail.gmail.com>
<[email protected]>
On Wed, 6 Nov 2024 at 12:09, Tom Lane <[email protected]> wrote:
> Of course, I might be overestimating the performance benefit we'd get.
> But I'm tempted to give it a try.
I'm glad. I'm curious to see if you're right about the projection
overhead of the flags. If you're right, it seems like a not too
difficult optimisation to get in.
I like the idea as it also gets rid of the flag cruft from
prepunion.c, which saves having to add flags conditionally if
INTERCEPT/EXCEPT were ever made to use joins.
David
view thread (4+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Why not do distinct before SetOp
In-Reply-To: <CAApHDvrXUuhGJ_rzsuLY3f1mou1w5RT4zxEb45gbBR3ap6vy4g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox