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
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 |