Would SSD improve Index Only Scan performance by a lot?

Поиск
Список
Период
Сортировка
От Arya F
Тема Would SSD improve Index Only Scan performance by a lot?
Дата
Msg-id CAFoK1axtgKBb-K4ssJ5fiAZgX=abX2Eq-e0m+zXfFifNyg0P5g@mail.gmail.com
обсуждение исходный текст
Ответы Sv: Would SSD improve Index Only Scan performance by a lot?  (Andreas Joseph Krogh <andreas@visena.com>)
Re: Would SSD improve Index Only Scan performance by a lot?  (Rick Otten <rottenwindfish@gmail.com>)
Re: Would SSD improve Index Only Scan performance by a lot?  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-performance
Дерево обсуждения
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?

В списке pgsql-performance по дате отправления:

Предыдущее
От: Ogden Brash
Дата:
Сообщение: Modification of data in base folder and very large tables
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: Sv: Would SSD improve Index Only Scan performance by a lot?