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

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Avoid re-checking for visibility map extension too frequently.
Date: 2012-02-02 01:40:11
Message-ID: E1Rslel-0006Bb-SW@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message User Fxjr 2012-02-02 13:46:18 npgsql - Npgsql2: Applied patch #1011157.
Previous Message Peter Eisentraut 2012-02-01 19:20:31 pgsql: initdb: Add options --auth-local and --auth-host