SSDs and Vertica

Under what circumstances could SSDs help improve Vertica performance?

Comments

  • Old_CommunityOld_Community Registered User
    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