It is documented that intbig utilizes 4096 bit signatures to represent the set nodes in the tree. However, I am unable to find any reference to a 4kbit signature in the code and am wondering where this is implemented.
_int.h: /* bigint defines */ #define SIGLENINT 63 /* >122 => key will toast, so very slow!!! */ #define SIGLEN ( sizeof(int)*SIGLENINT ) #define SIGLENBIT (SIGLEN*BITS_PER_BYTE)
63 /*ints*/ * 4 /* byte per int */ * 8 /* bits per byte */ = 2016 bits From our experience, using power of 2 number of bits causes bad hashing of array. You can play with value of SIGLENINT: - less value decreases index's size, but increase number of false drops, so index will return more values and pgsql will drop it after rechecking of table's value. That increases table's access - greater value increase index's size but decrease number of false drops. So, you can find optimal SIGLENINT value for your sets of data.
Also, is the leaf comparison also a signature comparison like the nodes? Or is this an exact comparison? From my understanding of the
What do you mean: comparison of signatures? RD-Tree doesn't use any comparison functions like B-Tree does. Here we use distance function. Distance might be defined in different meaning, but we use Hemming distance (_intbig_gist.c:hemdistsign) which is number of different bits in signatures.
code, it doesn’t appear to be an exact comparison. If this is the case, how can I access the original intarray that is being referenced by this signature?
Index doesn't store original int at all. From GiST support fuction there is no way to get access to table's value :(.
-- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org