Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

SSDs and Vertica

Under what circumstances could SSDs help improve Vertica performance?


  • If there are too few spinning disks per node to support the seek rate (either in an individual query plan, or when approaching optimal concurrency for full CPU utilization), SSD might help speed up queries. To make more cost-effective use of SSDs, you may consider using them only for frequently accessed columns or for temporary data such as spill-to-disk operations like large sorts, JOINs, and GROUP BYs. See Documentation for details.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.