Re: why SSD is slower than HDD SAS 15K ?

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: why SSD is slower than HDD SAS 15K ?
Дата
Msg-id CALd+dcc324VveLc4CX=Om7Yosdn1iH7ud8ytk11VZHhFmbDCHQ@mail.gmail.com
обсуждение исходный текст
Ответ на why SSD is slower than HDD SAS 15K ?  (Neto pr <netoprbr9@gmail.com>)
Ответы Re: why SSD is slower than HDD SAS 15K ?  (Neto pr <netoprbr9@gmail.com>)
Список pgsql-general
Try random page cost 1.1. Way back when I started using SSD we had a discussion here and came to the conclusion that it should be ever so slightly higher than sequential page cost.

It is very hard to read your query plans (maybe gmail is wrapping them funny or you need to use a fixed font on them or share them from https://explain.depesz.com), but they do look substantially different. My guess is that with the random page cost = sequential page cost you are tricking Pg into using more sequential scans than index searches.

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

Предыдущее
От: Kellner Thiemo
Дата:
Сообщение: RE: pg_basebackup is taking more time than expected
Следующее
От: Neto pr
Дата:
Сообщение: Re: why SSD is slower than HDD SAS 15K ?