På onsdag 09. oktober 2019 kl. 01:37:06, skrev Arya F <arya6...@gmail.com
<mailto:arya6...@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
andr...@visena.com <mailto:andr...@visena.com> www.visena.com
<https://www.visena.com> <https://www.visena.com>
