Re: Changing the default random_page_cost value - Mailing list pgsql-hackers

From Roberto Mello
Subject Re: Changing the default random_page_cost value
Date
Msg-id CAKz==bJeWBxHnRCHTZdXvybsrS5O6w1r=2RFuawtAPgiZy2=5w@mail.gmail.com
Whole thread Raw
In response to Changing the default random_page_cost value  (Greg Sabino Mullane <htamfids@gmail.com>)
List 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 by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Changing the default random_page_cost value
Next
From: Shubham Khanna
Date:
Subject: Re: Pgoutput not capturing the generated columns