Would SSD improve Index Only Scan performance by a lot?
Arya F <[email protected]> Tue, 8 Oct 2019 19:37:06 -0400
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <CAFoK1axtgKBb-K4ssJ5fiAZgX=abX2Eq-e0m+zXfFifNyg0P5g@mail.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?