pgsql: Modify btree to delete known-dead index entries without an actual

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Modify btree to delete known-dead index entries without an actual
Date: 2006-07-25 19:13:00
Message-ID: 20060725191300.AC08D9FA65C@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Modify btree to delete known-dead index entries without an actual VACUUM.
When we are about to split an index page to do an insertion, first look
to see if any entries marked LP_DELETE exist on the page, and if so remove
them to try to make enough space for the desired insert. This should reduce
index bloat in heavily-updated tables, although of course you still need
VACUUM eventually to clean up the heap.

Junji Teramoto

Modified Files:
--------------
pgsql/src/backend/access/nbtree:
README (r1.12 -> r1.13)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/nbtree/README.diff?r1=1.12&r2=1.13)
nbtinsert.c (r1.141 -> r1.142)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/nbtree/nbtinsert.c.diff?r1=1.141&r2=1.142)
nbtpage.c (r1.98 -> r1.99)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/nbtree/nbtpage.c.diff?r1=1.98&r2=1.99)
nbtutils.c (r1.77 -> r1.78)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/nbtree/nbtutils.c.diff?r1=1.77&r2=1.78)
nbtxlog.c (r1.35 -> r1.36)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/nbtree/nbtxlog.c.diff?r1=1.35&r2=1.36)
pgsql/src/include/access:
nbtree.h (r1.101 -> r1.102)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/access/nbtree.h.diff?r1=1.101&r2=1.102)

Browse pgsql-committers by date

  From Date Subject
Next Message User Gsmet 2006-07-25 21:07:26 pgfouine - pgfouine: updated usage with history report
Previous Message Bruce Momjian 2006-07-25 16:23:42 pgsql: Add reason for WAL offset reporting: > > The offset allows