pgsql: Fix adjust_semi_join to be more cautious about clauseless joins.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix adjust_semi_join to be more cautious about clauseless joins.
Date: 2010-11-02 22:46:12
Message-ID: E1PDPcK-0003Ct-9w@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix adjust_semi_join to be more cautious about clauseless joins.

It was reporting that these were fully indexed (hence cheap), when of
course they're the exact opposite of that. I'm not certain if the case
would arise in practice, since a clauseless semijoin is hard to produce
in SQL, but if it did happen we'd make some dumb decisions.

Branch
------
REL8_4_STABLE

Details
-------
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=55c3a7c0a5b335f03bf1bd26f1b7542d5305d256

Modified Files
--------------
src/backend/optimizer/path/costsize.c | 18 +++++++++++++-----
1 files changed, 13 insertions(+), 5 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Greg Stark 2010-11-03 09:34:30 Re: pgsql: Bootstrap WAL to begin at segment logid=0 logseg=1 (000000010000
Previous Message Tom Lane 2010-11-02 21:32:19 pgsql: Fix buffer overrun in pg_upgrade.