Materialize Logo

ALTER INDEX

New in v0.4.3.

ALTER INDEX changes the parameters of an index.

Syntax

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.

Details

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.

Examples

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