Horton

Would SSD improve Index Only Scan performance by a lot?

Arya F <arya6000@gmail.com>

View thread View on postgr.es
From: Arya F <arya6000@gmail.com>
To: pgsql-performance@lists.postgresql.org
Date: 2019-10-08T23:37:06Z
Lists: pgsql-performance 
As my table has gotten bigger, it takes longer to get a single row back
when querying a row by its btree index.

Right now the database is running on a traditional HDD. SSDs have a much
faster seek time than traditional HDDs.

Would switching to an SSD improve "Index Only Scan" time greatly? by at
least 3-4 times?