Re: pgsql: Increase default maintenance_io_concurrency to 16

2025-03-18 Thread Andres Freund
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. Greetings, And

Re: pgsql: Increase default maintenance_io_concurrency to 16

2025-03-18 Thread Bruce Momjian
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. --- On Tue, Mar 18, 2025 at 01:08:47PM +, Melanie Plageman

pgsql: Increase default maintenance_io_concurrency to 16

2025-03-18 Thread Melanie Plageman
Increase default maintenance_io_concurrency to 16 Since its introduction in fc34b0d9de27a, the default maintenance_io_concurrency has been larger than the default effective_io_concurrency. maintenance_io_concurrency primarily controlled prefetching done on behalf of the whole system, for operation