Sv: Would SSD improve Index Only Scan performance by a lot?

På onsdag 09. oktober 2019 kl. 01:37:06, skrev Arya F <arya6000@gmail.com 
<mailto:arya6000@gmail.com>>: 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) ismuch faster with 
SSD. -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 
andreas@visena.com <mailto:andreas@visena.com> www.visena.com 
<https://www.visena.com>  <https://www.visena.com>