pgsql: Reduce lock levels for table storage params related to planning

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Reduce lock levels for table storage params related to planning
Date: 2017-03-06 10:40:38
Message-ID: E1ckq4E-00074V-4v@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Reduce lock levels for table storage params related to planning

The following parameters are now updateable with ShareUpdateExclusiveLock
effective_io_concurrency
parallel_workers
seq_page_cost
random_page_cost
n_distinct
n_distinct_inherited

Simon Riggs and Fabrízio Mello

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/21d4e2e20656381b4652eb675af4f6d65053607f

Modified Files
--------------
src/backend/access/common/reloptions.c | 50 +++++++++++++++++++++++++++++-----
src/backend/utils/cache/spccache.c | 11 ++++++++
2 files changed, 54 insertions(+), 7 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Simon Riggs 2017-03-06 11:21:42 pgsql: Enhance docs for ALTER TABLE lock levels of storage parms
Previous Message Simon Riggs 2017-03-06 10:24:22 pgsql: Allow partitioned tables to be dropped without CASCADE