pgsql: Avoid re-checking for visibility map extension too frequently. - Mailing list pgsql-committers

From Robert Haas
Subject pgsql: Avoid re-checking for visibility map extension too frequently.
Date
Msg-id E1Rslel-0006Bb-SW@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Avoid re-checking for visibility map extension too frequently.

When testing bits (but not when setting or clearing them), we now
won't check whether the map has been extended.  This significantly
improves performance in the case where the visibility map doesn't
exist yet, by avoiding an extra system call per tuple.  To make
sure backends notice eventually, send an smgr inval on VM extension.

Dean Rasheed, with minor modifications by me.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/b4e0741727685443657b55932da0c06f028fbc00

Modified Files
--------------
src/backend/access/heap/visibilitymap.c |   25 ++++++++++++++++++++-----
1 files changed, 20 insertions(+), 5 deletions(-)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: initdb: Add options --auth-local and --auth-host
Next
From: fxjr@pgfoundry.org (User Fxjr)
Date:
Subject: npgsql - Npgsql2: Applied patch #1011157.