Increase default maintenance_io_concurrency to 16 - Mailing list pgsql-hackers

From Bruce Momjian
Subject Increase default maintenance_io_concurrency to 16
Date
Msg-id Z9nWFVBx3OJSwqg6@momjian.us
Whole thread Raw
Responses Re: Increase default maintenance_io_concurrency to 16
List pgsql-hackers
On Tue, Mar 18, 2025 at 04:13:26PM -0400, Andres Freund wrote:
> Hi,
> 
> On 2025-03-18 16:08:22 -0400, Bruce Momjian wrote:
> > This commit makes our default random_page_cost = 4 out of line with
> > these new settings (assumes modern SSD/NAS/SAN hardware) and more out of
> > line with reality.
> 
> How so? That seems like an independent consideration to me.

[thread moved to hackers]

Uh, I think our old random_page_cost and *_io_concurrency assumed
magnetic disks --- now *_io_concurrency assumes more modern hardware and
random_page_cost assumes magnetic.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Supporting TCP_SYNCNT in libpq
Next
From: Andres Freund
Date:
Subject: Re: Increase default maintenance_io_concurrency to 16