From b39e91501c101d67b92f3e6965da5dc111195f52 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 28 Jan 2007 23:21:26 +0000 Subject: Improve hash join to discard input tuples immediately if they can't match because they contain a null join key (and the join operator is known strict). Improves performance significantly when the inner relation contains a lot of nulls, as per bug #2930. --- src/include/executor/hashjoin.h | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'src/include/executor/hashjoin.h') diff --git a/src/include/executor/hashjoin.h b/src/include/executor/hashjoin.h index 59ebb6ebbd9..ba086407679 100644 --- a/src/include/executor/hashjoin.h +++ b/src/include/executor/hashjoin.h @@ -7,7 +7,7 @@ * Portions Copyright (c) 1996-2007, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $PostgreSQL: pgsql/src/include/executor/hashjoin.h,v 1.42 2007/01/05 22:19:54 momjian Exp $ + * $PostgreSQL: pgsql/src/include/executor/hashjoin.h,v 1.43 2007/01/28 23:21:26 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -108,6 +108,8 @@ typedef struct HashJoinTableData */ FmgrInfo *hashfunctions; /* lookup data for hash functions */ + bool *hashStrict; /* is each hash join operator strict? */ + Size spaceUsed; /* memory space currently used by tuples */ Size spaceAllowed; /* upper limit for space used */ -- cgit v1.2.3