Re: join selectivity

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: strk(at)refractions(dot)net
Cc: Mark Cave-Ayland <m(dot)cave-ayland(at)webbased(dot)co(dot)uk>, pgsql-hackers(at)postgresql(dot)org, postgis-devel(at)postgis(dot)refractions(dot)net
Subject: Re: join selectivity
Date: 2004-12-23 15:01:33
Message-ID: 28268.1103814093@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

strk(at)refractions(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-12-23 15:09:49 Re: Regression (semi)fix for netbsd-mac68k
Previous Message Andrew Dunstan 2004-12-23 10:45:57 Re: Regression (semi)fix for netbsd-mac68k