agora inbox for [email protected]
help / color / mirror / Atom feedFrom: Antonin Houska <[email protected]>
To: [email protected]
Subject: Re: Performance improvement for joins where outer side is unique
Date: Wed, 25 Jan 2017 16:56:21 +0100
Message-ID: <28690.1485359781@localhost> (raw)
In-Reply-To: <CAKJS1f9-WLTw78EkUgwbDLXz0Cn8qu6xHme-p4XNXO_Pwvm8OQ@mail.gmail.com>
References: <[email protected]>
<CAPpHfdviphQFjk-gaGZGGxLAyt=YuVdJLnntsxOKnU296s9u-Q@mail.gmail.com>
<CAKJS1f-=1y0-f5FFV2_r7LtS+CL2Lw-nhJjXB3O_0FmBqnK=3A@mail.gmail.com>
<27152324.eFKJb4Khb5@dinodell>
<[email protected]>
<[email protected]>
<CAKJS1f-9UTo6fA+h8rojd30CujSKscZamLn5YnKw5+ASbV0Wwg@mail.gmail.com>
<[email protected]>
<CAKJS1f_8hrzTDCu0pwERWj_dLZu-6DYFQJAtNT+vM6UeOn0kHw@mail.gmail.com>
<[email protected]>
<CAKJS1f8JCt15ngEP8sZO-JYYT8mS6HUP_CT0T6S_0ogk1kQt+Q@mail.gmail.com>
<CAKJS1f_4hm3qwKeHYKftd+BQuYBgdNR+rk+XP_JW9EY-ALHZbQ@mail.gmail.com>
<[email protected]>
<CAKJS1f_i7dGh9ytc0DuaX3JJaN7Gp9AGXNbdtWjj0PkPzNzUeg@mail.gmail.com>
<[email protected]>
<CANP8+j+vxfEf3dqhnzKAnDopnnUM-Zjb90gNT=haEQNQePj9Mw@mail.gmail.com>
<CAKJS1f8MpcL4_oS+n-vmnisd_8OMuZR2vyLETOF7ABSLk_iNZg@mail.gmail.com>
<[email protected]>
<CAKJS1f8S6FH_eH71SXmo_m2 [email protected]>
<[email protected]>
<CAKJS1f8naKkOueF0yRaTPzErzyLHjcOCwKvVnr5a4rv4doNzHw@mail.gmail.com>
<CAKJS1f_TwwnJoXFgmwY39L81u9e6HiRuO1dnnCy2EFuHLaeYCQ@mail.gmail.com>
<[email protected]>
<CAKJS1f9OrAkVywOvk5OhCoXOssGUmtYOQyhU8jFr_bZL+Xn6zQ@mail.gmail.com>
<CAKJS1f_BxfNe3ixfz4S-g2RTodvjk82edcv9O9WtBqc9eUbWSA@mail.gmail.com>
<[email protected]>
<CAKJS1f96jZYcv69rN-N_d+SpFqB4-4yBt0p_+fyPY=ESmj7Jzg@mail.gmail.com>
<CAKJS1f-cJS2byqdHr7=KFBMt22GsU1ij42OEZV6q8eorSdvztw@mail.gmail.com>
<CAJrrPGctNgAuGZWojS=7_=pyhCY7qZZmCyZ8vJ4Emc5N1ODvBA@mail.gmail.com>
<[email protected]>
<[email protected]>
<CAKJS1f_VX2z=XRSS=mCcCYYtBmVr-3YVeRVroS-WEOBAA4iVbg@mail.gmail.com>
<CAKJS1f9-WLTw78EkUgwbDLXz0Cn8qu6xHme-p4XNXO_Pwvm8OQ@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-hackers>
David Rowley <[email protected]> wrote:
> On 19 January 2017 at 11:06, David Rowley <[email protected]> wrote:
> > Old patch no longer applies, so I've attached a rebased patch. This
> > also re-adds a comment line which I mistakenly removed.
>
> (meanwhile Andres commits 69f4b9c)
>
> I should've waited a bit longer.
>
> Here's another that fixes the new conflicts.
I suspect that "inner" and "outer" relation / tuple are sometimes confused in
comments:
* analyzejoins.c:70
"searches for subsequent matching outer tuples."
* analyzejoins.c:972
/*
* innerrel_is_unique
* Check for proofs which prove that 'innerrel' can, at most, match a
* single tuple in 'outerrel' based on the join condition in
* 'restrictlist'.
*/
* relation.h:1831
bool inner_unique; /* inner side of join matches no more than one
* outer side tuple */
--
Antonin Houska
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt
Web: http://www.postgresql-support.de, http://www.cybertec.at
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
view thread (132+ messages) latest in thread
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]
Subject: Re: Performance improvement for joins where outer side is unique
In-Reply-To: <28690.1485359781@localhost>
* 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