From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: James Wang <jwang25610@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: brininsert optimization opportunity
Date: Mon, 8 Jan 2024 12:23:14 +0100
Message-ID: <202401081123.3qqe5qokxyo2@alvherre.pgsql> (raw)
In-Reply-To: <170315311175.2631681.12214566971840476644.pgcf@coridan.postgresql.org>
On 2023-Dec-21, James Wang wrote:
> Hi All, not sure how to "Specify thread msgid" - choose one which i think is close to my new feature request.
Hello James, based on the "Specify thread msgid" message it looks like
you were trying to request a feature using the Commitfest website? That
won't work; the commitfest website is only intended as a tracker of
in-progress development work. Without a Postgres code patch, that
website doesn't help you any. What you have done amounts to hijacking
an unrelated mailing list thread, which is discouraged and frowned upon.
That said, sadly we don't have any official feature request system,
Please start a new thread by composing an entirely new message to
pgsql-hackers@lists.postgresql.org, and don't use the commitfest
website for it.
That said,
> query:
>
> SELECT count(1) FROM table1 t1 JOIN table2 t2 ON t1.id = t2.id WHERE t1.a_indexed_col='some_value' OR t2.a_indexed_col='some_vable';
>
> can the server automatically replace the OR logic above with UNION please? i.e. replace it with:
>
> (SELECT count(1) FROM table1 t1 JOIN table2 t2 ON t1.id = t2.id WHERE t1.a_indexed_col='some_value' )
> UNION
> (SELECT count(1) FROM table1 t1 JOIN table2 t2 ON t1.id = t2.id WHERE t2.a_indexed_col='some_vable');
I have the feeling that this has already been discussed, but I can't
find anything useful in the mailing list archives.
--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/
"Saca el libro que tu religión considere como el indicado para encontrar la
oración que traiga paz a tu alma. Luego rebootea el computador
y ve si funciona" (Carlos Duclós)
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: pgsql-hackers@postgresql.org
Cc: alvherre@alvh.no-ip.org, jwang25610@gmail.com, pgsql-hackers@lists.postgresql.org
Subject: Re: brininsert optimization opportunity
In-Reply-To: <202401081123.3qqe5qokxyo2@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox