pgsql: Don't bother to lock bufmgr partitions in pg_buffercache.

From: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Don't bother to lock bufmgr partitions in pg_buffercache.
Date: 2016-09-29 10:17:27
Message-ID: E1bpYP9-0002nK-G1@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Don't bother to lock bufmgr partitions in pg_buffercache.

That makes the view a lot less disruptive to use on a production system.
Without the locks, you don't get a consistent snapshot across all buffers,
but that's OK. It wasn't a very useful guarantee in practice.

Ivan Kartyshov, reviewed by Tomas Vondra and Robert Haas.

Discusssion: <f9d6cab2-73a7-7a84-55a8-07dcb8516ae5(at)postgrespro(dot)ru>

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/6e654546fb61f62cc982d0c8f62241b3b30e7ef8

Modified Files
--------------
contrib/pg_buffercache/pg_buffercache_pages.c | 23 ++++-------------------
1 file changed, 4 insertions(+), 19 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2016-09-29 15:32:22 pgsql: Switch pg_basebackup commands in Postgres.pm to use --nosync
Previous Message Peter Eisentraut 2016-09-29 01:54:45 pgsql: Exclude additional directories in pg_basebackup