Hi hackers,<br /><br />I found that some parameters of GiST implementation are builin in the code. For example,
followingcan be found in the backend/utils/adt/tsgistidx.c:<br /><br />#define SIGLENINT 31 /* >121
=>key will toast, so it will not work<br /> * !!! */<br /><br />#define SIGLEN (
sizeof(int4)* SIGLENINT )<br />#define SIGLENBIT (SIGLEN * BITS_PER_BYTE)<br /><br />I think that such parameters don't
haveoptimal value for all the cases; and it would be a great option to let user define such parameters for particular
index.<br/> For example, following syntax can be used:<br /><br />CREATE INDEX name ON table USING gist(column) WITH
(SIGLENINT=63);<br/><br />With best regards,<br />Korotkov Alexander.<br />