Re: effective_io_concurrency's steampunk spindle maths - Mailing list pgsql-hackers

From Michael Banck
Subject Re: effective_io_concurrency's steampunk spindle maths
Date
Msg-id 5e62b7f3.1c69fb81.c17bc.7a50@mx.google.com
Whole thread Raw
In response to effective_io_concurrency's steampunk spindle maths  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: effective_io_concurrency's steampunk spindle maths
List pgsql-hackers
Hi,

On Mon, Mar 02, 2020 at 06:28:41PM +1300, Thomas Munro wrote:
> Should we rename it?  Here are my first suggestions:
> 
> maintenance_random_page_prefetch_degree
> 
> Rationale for this naming pattern:
[...]
> * "maintenance_" prefix is like other GUCs that establish (presumably
> larger) limits for processes working on behalf of many user sessions

I'm a bit skeptical about this - at least in V12 there's only two GUCs
with 'maintenance' in the name:  maintenance_work_mem and
max_parallel_maintenance_workers. Both are used for utility commands and
do not apply to regular user queries while (AFAICT) your proposal is not
limited to utility commands. So I think if you name it
'maintenance'-something, people will assume it only involves VACUUM or
so.


Michael

-- 
Michael Banck
Projektleiter / Senior Berater
Tel.: +49 2166 9901-171
Fax:  +49 2166 9901-100
Email: michael.banck@credativ.de

credativ GmbH, HRB Mönchengladbach 12080
USt-ID-Nummer: DE204566209
Trompeterallee 108, 41189 Mönchengladbach
Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer

Unser Umgang mit personenbezogenen Daten unterliegt
folgenden Bestimmungen: https://www.credativ.de/datenschutz



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: effective_io_concurrency's steampunk spindle maths
Next
From: Thomas Munro
Date:
Subject: Re: effective_io_concurrency's steampunk spindle maths