På onsdag 09. oktober 2019 kl. 01:37:06, skrev Arya F <arya6000(at)gmail(dot)com
<mailto:arya6000(at)gmail(dot)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(at)visena(dot)com <mailto:andreas(at)visena(dot)com> www.visena.com
<https://www.visena.com> <https://www.visena.com>