pgsql: Allow per-tablespace effective_io_concurrency

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Allow per-tablespace effective_io_concurrency
Date: 2015-09-08 15:59:15
Message-ID: E1ZZLIh-0005Wf-AX@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Allow per-tablespace effective_io_concurrency

Per discussion, nowadays it is possible to have tablespaces that have
wildly different I/O characteristics from others. Setting different
effective_io_concurrency parameters for those has been measured to
improve performance.

Author: Julien Rouhaud
Reviewed by: Andres Freund

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/1aba62ec635f5852bc45ce65482366e541e61ff5

Modified Files
--------------
doc/src/sgml/config.sgml | 5 ++-
doc/src/sgml/ref/create_tablespace.sgml | 17 ++++----
src/backend/access/common/reloptions.c | 16 +++++++-
src/backend/executor/nodeBitmapHeapscan.c | 35 ++++++++++++----
src/backend/storage/buffer/bufmgr.c | 63 ++++++++++++++++++++++++++++-
src/backend/utils/cache/spccache.c | 12 ++++++
src/backend/utils/misc/guc.c | 45 ++-------------------
src/bin/psql/tab-complete.c | 2 +-
src/include/commands/tablespace.h | 1 +
src/include/nodes/execnodes.h | 4 +-
src/include/storage/bufmgr.h | 7 ++++
src/include/utils/spccache.h | 1 +
12 files changed, 145 insertions(+), 63 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Thom Brown 2015-09-08 16:07:16 Re: pgsql: Allow per-tablespace effective_io_concurrency
Previous Message Alvaro Herrera 2015-09-08 14:11:25 pgsql: Fix error message wording in previous sslinfo commit