Horton

Introduce a maintenance_io_concurrency setting.

Thomas Munro <tmunro@postgresql.org>

View on postgr.es
Commit: fc34b0d9de27ab5ac2887da00b3892bdabd89e45
Author: Thomas Munro <tmunro@postgresql.org>
Date: 2020-03-16T04:14:26Z
Releases: 13.0 
Introduce a maintenance_io_concurrency setting.

Introduce a GUC and a tablespace option to control I/O prefetching, much
like effective_io_concurrency, but for work that is done on behalf of
many client sessions.

Use the new setting in heapam.c instead of the hard-coded formula
effective_io_concurrency + 10 introduced by commit 558a9165e08.  Go with
a default value of 10 for now, because it's a round number pretty close
to the value used for that existing case.

Discussion: https://postgr.es/m/CA%2BhUKGJUw08dPs_3EUcdO6M90GnjofPYrWp4YSLaBkgYwS-AqA%40mail.gmail.com

Files

PathChange+/−
doc/src/sgml/config.sgml modified +20 −0
doc/src/sgml/ref/alter_tablespace.sgml modified +7 −4
doc/src/sgml/ref/create_tablespace.sgml modified +7 −4
src/backend/access/common/reloptions.c modified +15 −1
src/backend/access/heap/heapam.c modified +3 −13
src/backend/storage/buffer/bufmgr.c modified +7 −0
src/backend/utils/cache/spccache.c modified +14 −0
src/backend/utils/misc/guc.c modified +32 −0
src/bin/psql/tab-complete.c modified +1 −1
src/include/commands/tablespace.h modified +1 −0
src/include/storage/bufmgr.h modified +1 −0
src/include/utils/spccache.h modified +1 −0

Documentation touched

Discussion