The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

SSDs and Vertica

Under what circumstances could SSDs help improve Vertica performance?

Comments

  • 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
Emoji
Image
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.