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

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема Sv: Would SSD improve Index Only Scan performance by a lot?
Дата
Msg-id VisenaEmail.0.be1ddf58563b9542.16dadbe454a@tc7-visena
обсуждение исходный текст
Ответ на Would SSD improve Index Only Scan performance by a lot?  (Arya F <arya6000@gmail.com>)
Список pgsql-performance
Дерево обсуждения
På onsdag 09. oktober 2019 kl. 01:37:06, skrev Arya F <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) is much faster with SSD.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Вложения

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

Предыдущее
От: Arya F
Дата:
Сообщение: Would SSD improve Index Only Scan performance by a lot?
Следующее
От: Rick Otten
Дата:
Сообщение: Re: Would SSD improve Index Only Scan performance by a lot?