[HACKERS] copying a bucket to a BufFile

2005-06-07 Thread mchron
hi, I'm trying to copy the contents of a bucket of a hash table to a BufFile. There is a memory context for each bucket. That is, there is an array (#nbuckets) memory contexts. thus the tree of mem cxts are ... hashCxt | batchCxt | | | | BucketCxt... BucketCxt

[HACKERS] SortMem...

2005-04-12 Thread mchron
Hi 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

[HACKERS] ERROR: unrecognized node type in PostgresMain( )

2005-03-08 Thread mchron
Perhaps you should rebuild the backend with -g (see --enable-debug) so that gdb can actually be somewhat helpful. It's usually a good idea to have --enable-cassert turned on when hacking C code, too. When I rebuilded the backend with --enable-debug and --enable-cassert the database stops and

[HACKERS] ERROR: unrecognized node type in PostgresMain( )

2005-03-06 Thread mchron
Hi I'm implementing a new join that needs 2 hash tables, one for each relation. I declared a new type of node, DPHashJoin (with id T_DPHashJoin 121 at nodes.h) , which is by now the same as HashJoin plan node.I created a new plan with two Hash nodes, something that looks like a symmetric hash