Introduce a maintenance_io_concurrency setting.
authorThomas Munro <tmunro@postgresql.org>
Sun, 15 Mar 2020 23:31:34 +0000 (12:31 +1300)
committerThomas Munro <tmunro@postgresql.org>
Mon, 16 Mar 2020 04:14:26 +0000 (17:14 +1300)
commitfc34b0d9de27ab5ac2887da00b3892bdabd89e45
treebfa65c51892f19538b6e7e53633654ddce5eb989
parentb09ff53667ffc986371ec8ffa372916ad460220d
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
12 files changed:
doc/src/sgml/config.sgml
doc/src/sgml/ref/alter_tablespace.sgml
doc/src/sgml/ref/create_tablespace.sgml
src/backend/access/common/reloptions.c
src/backend/access/heap/heapam.c
src/backend/storage/buffer/bufmgr.c
src/backend/utils/cache/spccache.c
src/backend/utils/misc/guc.c
src/bin/psql/tab-complete.c
src/include/commands/tablespace.h
src/include/storage/bufmgr.h
src/include/utils/spccache.h