pgsql: Introduce a maintenance_io_concurrency setting.

From: Thomas Munro <tmunro(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Introduce a maintenance_io_concurrency setting.
Date: 2020-03-16 04:24:25
Message-ID: E1jDhIf-00041w-Ns@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/fc34b0d9de27ab5ac2887da00b3892bdabd89e45

Modified Files
--------------
doc/src/sgml/config.sgml | 20 ++++++++++++++++++++
doc/src/sgml/ref/alter_tablespace.sgml | 11 +++++++----
doc/src/sgml/ref/create_tablespace.sgml | 11 +++++++----
src/backend/access/common/reloptions.c | 16 +++++++++++++++-
src/backend/access/heap/heapam.c | 16 +++-------------
src/backend/storage/buffer/bufmgr.c | 7 +++++++
src/backend/utils/cache/spccache.c | 14 ++++++++++++++
src/backend/utils/misc/guc.c | 32 ++++++++++++++++++++++++++++++++
src/bin/psql/tab-complete.c | 2 +-
src/include/commands/tablespace.h | 1 +
src/include/storage/bufmgr.h | 1 +
src/include/utils/spccache.h | 1 +
12 files changed, 109 insertions(+), 23 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Alexander Korotkov 2020-03-16 11:54:43 Re: pgsql: Add kqueue(2) support to the WaitEventSet API.
Previous Message Peter Geoghegan 2020-03-16 03:54:45 pgsql: nbtree: Reorder nbtinsert.c prototypes.