Обсуждение: pgsql: Avoid re-checking for visibility map extension too frequently.

Поиск
Список
Период
Сортировка

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

От
Robert Haas
Дата:
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(-)