Materialize Logo


New in v0.4.3.

ALTER INDEX changes the parameters of an index.


ALTER INDEX name SET ( field = val , RESET ( field , )
Field Use
name The identifier of the index you want to alter.
field The name of the parameter you want to alter.
val The new value for the parameter.


Available parameters

Name Meaning
logical_compaction_window Overrides the logical compaction window for the data stored in this index. The default value is controlled by the --logical-compaction-window command-line option.


To adjust the logical compaction window for the index named some_primary_idx:

ALTER INDEX some_primary_idx SET (logical_compaction_window = '500ms')

To reset the logical compaction window to its default value:

ALTER INDEX some_primary_idx RESET (logical_compaction_window)

See also

Did this info help?
Yes No