in the function ExecChooseHashTableSize() (~/src/backend/executor/nodeHash.c)
are determined the bytes of the hash table. The correspondent code is:
/*
* Target in-memory hashtablesize in SortMem kilobytes
*/
hash_table_bytes = SortMem *1024L
(~/src/include/miscadmin.h)
extern DLLIMPORT int SortMem;
What SortMem represents? Where is evaluated and what is its value?
I want to create 2 hash tables. One for the inner and one for the outer rel. What should be the hash_table_bytes in that case?
Thanks in advance! -martha
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
