Re: Changing the default random_page_cost value

Поиск
Список
Период
Сортировка
От Roberto Mello
Тема Re: Changing the default random_page_cost value
Дата
Msg-id CAKz==bJeWBxHnRCHTZdXvybsrS5O6w1r=2RFuawtAPgiZy2=5w@mail.gmail.com
обсуждение исходный текст
Ответ на Changing the default random_page_cost value  (Greg Sabino Mullane <htamfids@gmail.com>)
Список pgsql-hackers
On Fri, Sep 27, 2024 at 8:07 AM Greg Sabino Mullane <htamfids@gmail.com> wrote:
tl;dr let's assume SSDs are popular and HDDs are the exception and flip our default

<snip>
 
Granted, there are other factors involved, and yes, perhaps we should tweak some of the similar settings as well, but ranom_page_cost is the one setting most out of sync with today's hardware realities. So I'll be brave and throw a number out there: 1.2. And change our docs to say wordage like "if you are using an older hard disk drive technology, you may want to try raising rpc" to replace our fairly-hidden note about SSDs buried in the last sentence - of the fourth paragraph - of the rpc docs.

+1

I suggest a slightly nicer comment in the default conf file, like "For spinning hard drives, raise this to at least 3 and test"

Roberto

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