På onsdag 09. oktober 2019 kl. 01:37:06, skrev Arya F <arya6000@xxxxxxxxx>:
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?
It depends on whether the index is accessed often or not (wrt. caching), and (of course) the size of the index, but yes - "cold access" to the index (or persistent data in general) is much faster with SSD.
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
