Eon mode/How to change number of Shard

Kaito

Do you know how to increase or decrease number of Shards? My customer possibly wants to re-design the number for performance tuning reason.

Thanks in advance,

Jim_Knicely

Hi,

The Shard count cannot be changed after database creation.

See:
https://www.vertica.com/blog/understanding-vertica-eon-mode/

In particular:

At the time of database creation, you specify how many shards are created. Once this value is defined, it cannot be changed.

Kaito

Thank you, Jim!