Skip to main content

Eon mode/How to change number of Shard

  • Dec 25, 2018 2:44 AM UTC
  • 2 replies
  • 13 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
  • Jan 4, 2019 3:11 PM UTC

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
  • Jan 9, 2019 9:15 AM UTC

Thank you, Jim!