Re: join selectivity - Mailing list pgsql-hackers

From Tom Lane
Subject Re: join selectivity
Date
Msg-id 28268.1103814093@sss.pgh.pa.us
Whole thread Raw
In response to Re: join selectivity  ("Mark Cave-Ayland" <m.cave-ayland@webbased.co.uk>)
Responses Re: join selectivity
List pgsql-hackers
strk@refractions.net writes:
> Doing some tests I've found out that the returned value from the
> JOINSEL is applied to REL1.rows X REL2.rows, but REL1 and REL2
> are not 'base' table, rather relations with a number of 
> rows once again estimated by other selectivity functions.

Right.  This amounts to assuming that the join conditions and the
restriction conditions are independent, which of course is bogus,
but we really don't have enough information to do better.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Andrew Dunstan"
Date:
Subject: Re: Regression (semi)fix for netbsd-mac68k
Next
From: Tom Lane
Date:
Subject: Re: Regression (semi)fix for netbsd-mac68k