To reproduce

ALTER MATERIALIZED VIEW candles_market_spot_0_5m ALTER COLUMN candle_symbol ADD INDEX;
ERROR:  'capacity' keyword expected

ALTER MATERIALIZED VIEW candles_market_spot_0_5m ALTER COLUMN candle_symbol CAPACITY 8192 ADD INDEX;
ERROR:  'symbol capacity', 'add index' or 'drop index' expected
LINE 1: ...ndles_market_spot_0_5m ALTER COLUMN candle_symbol CAPACITY 8...

QuestDB version:

9.2.0

OS, in case of Docker specify Docker and the Host OS:

Ubuntu 22.04 Docker

File System, in case of Docker specify Host File System:

ZFS

Full Name:

Maksim Tulupov

Affiliation:

Coinmetrics

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

• Yes, I have

Additional context

No response