| From: | tgl(at)svr1(dot)postgresql(dot)org (Tom Lane) |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql-server: Arrange for hash join to skip scanning the outer relation |
| Date: | 2004-09-22 19:13:53 |
| Message-ID: | 20040922191353.E1EDD329E8E@svr1.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Log Message:
-----------
Arrange for hash join to skip scanning the outer relation if it detects
that the inner one is completely empty. Per recent discussion. Also some
cosmetic cleanups in nearby code.
Modified Files:
--------------
pgsql-server/src/backend/executor:
nodeHash.c (r1.86 -> r1.87)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/executor/nodeHash.c.diff?r1=1.86&r2=1.87)
nodeHashjoin.c (r1.65 -> r1.66)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/executor/nodeHashjoin.c.diff?r1=1.65&r2=1.66)
pgsql-server/src/include/executor:
hashjoin.h (r1.32 -> r1.33)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/executor/hashjoin.h.diff?r1=1.32&r2=1.33)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2004-09-23 00:30:19 | pgsql-server: Update installation docs for PL/Python to note that |
| Previous Message | Tom Lane | 2004-09-22 19:11:23 | pgsql-server: Issue a CHECKPOINT just after creating the regression |