Parameters of GiST indexes - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Parameters of GiST indexes
Date
Msg-id AANLkTilybCC9tpa1j7xNluUo8U1g8lI2HVLkAv2a_F8g@mail.gmail.com
Whole thread Raw
Responses Re: Parameters of GiST indexes  (Robert Haas <robertmhaas@gmail.com>)
List 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 by date:

Previous
From: Randy Solomonson
Date:
Subject: How to get permission to debug postgres?
Next
From: Alexander Korotkov
Date:
Subject: Using multidimensional indexes in ordinal queries