Simon Riggs <[EMAIL PROTECTED]> writes: > Just wanted to make clear to Hackers that the gates are now open to > include other parameters for CREATE INDEX, as originally requested here: > http://archives.postgresql.org/pgsql-hackers/2005-09/msg00851.php
Just to follow up on the discussion of that thread: what's been implemented is a way to store arbitrary name=value strings in an index's pg_class entry, and to make these available in a pre-parsed form through the index relcache entry. However you'd have to be cautious about using the values directly for any fundamental index structure decisions, because ALTER INDEX will just change them without giving you an opportunity to modify the index in response. So depending on what you are doing, you might need to store the "real" values in the index metapage, and set those values from the reloptions parameters only at ambuild() time. This would mean that ALTER INDEX + REINDEX would be the procedure needed to change the structure of an existing index. OTOH, if you can tolerate on-the-fly changes of a parameter, then using it directly from the rd_options struct would be reasonable. Also: as of CVS tip ginoptions() accepts FILLFACTOR but nothing is done with it. Can you do something useful with FILLFACTOR in GIN? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match