| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Melanie Plageman <melanieplageman(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Increase default maintenance_io_concurrency to 16 |
| Date: | 2025-03-18 20:22:45 |
| Message-ID: | Z9nWFVBx3OJSwqg6@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers 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(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2025-03-18 20:27:18 | Re: Increase default maintenance_io_concurrency to 16 |
| Previous Message | Andres Freund | 2025-03-18 20:13:26 | Re: pgsql: Increase default maintenance_io_concurrency to 16 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2025-03-18 20:27:18 | Re: Increase default maintenance_io_concurrency to 16 |
| Previous Message | Andres Freund | 2025-03-18 20:18:24 | Re: Supporting TCP_SYNCNT in libpq |