ALTER INDEX
New in v0.4.3.
ALTER INDEX
changes the parameters of an index.
Syntax
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)