Re: Changing the default random_page_cost value

From: Roberto Mello <roberto(dot)mello(at)gmail(dot)com>
To: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Changing the default random_page_cost value
Date: 2024-09-27 14:26:38
Message-ID: CAKz==bJeWBxHnRCHTZdXvybsrS5O6w1r=2RFuawtAPgiZy2=5w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Sep 27, 2024 at 8:07 AM Greg Sabino Mullane <htamfids(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Shubham Khanna 2024-09-27 14:31:28 Re: Pgoutput not capturing the generated columns
Previous Message Greg Sabino Mullane 2024-09-27 14:07:14 Changing the default random_page_cost value