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)