Skip site navigation (1) Skip section navigation (2)

pgsql: Fix adjust_semi_join to be more cautious about clauselessjoins.

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 clauselessjoins.
Date: 2010-11-02 22:46:12
Message-ID: E1PDPcK-0003Cq-6U@gemulon.postgresql.org (view raw or flat)
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
------
master

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

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

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group