Parameters of GiST indexes
От | Alexander Korotkov |
---|---|
Тема | Parameters of GiST indexes |
Дата | |
Msg-id | AANLkTilybCC9tpa1j7xNluUo8U1g8lI2HVLkAv2a_F8g@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Parameters of GiST indexes
|
Список | pgsql-hackers |
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 />
В списке pgsql-hackers по дате отправления: