Skip to main content

Eon mode/How to change number of Shard

  • December 25, 2018
  • 2 replies
  • 7 views

Kaito
Forum|alt.badge.img+2
  • Participating Frequently

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,

2 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • January 4, 2019

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
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • January 9, 2019

Thank you, Jim!