Re: [HACKERS] Performance improvement for joins where outer side is unique - Mailing list pgsql-hackers

From Antonin Houska
Subject Re: [HACKERS] Performance improvement for joins where outer side is unique
Date
Msg-id 28690.1485359781@localhost
Whole thread Raw
In response to Re: [HACKERS] Performance improvement for joins where outer side is unique  (David Rowley <[email protected]>)
Responses Re: [HACKERS] Performance improvement for joins where outer side is unique
List pgsql-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



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: [HACKERS] pg_ls_dir & friends still have a hard-coded superuser check
Next
From: Antonin Houska
Date:
Subject: Re: [HACKERS] PoC: Grouped base relation