pgsql: Modify snapshot definition so that lazy vacuums are ignored by

From: alvherre(at)postgresql(dot)org (Alvaro Herrera)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Modify snapshot definition so that lazy vacuums are ignored by
Date: 2006-07-30 02:07:18
Message-ID: 20060730020718.B26C99FB2FB@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Modify snapshot definition so that lazy vacuums are ignored by other
vacuums. This allows a OLTP-like system with big tables to continue
regular vacuuming on small-but-frequently-updated tables while the
big tables are being vacuumed.

Original patch from Hannu Krossing, rewritten by Tom Lane and updated
by me.

Modified Files:
--------------
pgsql/src/backend/access/transam:
twophase.c (r1.21 -> r1.22)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/twophase.c.diff?r1=1.21&r2=1.22)
xact.c (r1.224 -> r1.225)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xact.c.diff?r1=1.224&r2=1.225)
xlog.c (r1.244 -> r1.245)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xlog.c.diff?r1=1.244&r2=1.245)
pgsql/src/backend/catalog:
index.c (r1.269 -> r1.270)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/index.c.diff?r1=1.269&r2=1.270)
pgsql/src/backend/commands:
vacuum.c (r1.335 -> r1.336)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/vacuum.c.diff?r1=1.335&r2=1.336)
pgsql/src/backend/storage/ipc:
procarray.c (r1.14 -> r1.15)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/ipc/procarray.c.diff?r1=1.14&r2=1.15)
pgsql/src/backend/storage/lmgr:
proc.c (r1.178 -> r1.179)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/lmgr/proc.c.diff?r1=1.178&r2=1.179)
pgsql/src/include/storage:
proc.h (r1.89 -> r1.90)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/proc.h.diff?r1=1.89&r2=1.90)
procarray.h (r1.9 -> r1.10)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/procarray.h.diff?r1=1.9&r2=1.10)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Meskes 2006-07-30 10:24:10 pgsql: Added missing $Header$ entries.
Previous Message Bruce Momjian 2006-07-30 01:48:40 pgsql: Add: > * Consider detoasting keys before sorting