pgsql: Modify btree to delete known-dead index entries without an actual
| От | tgl@postgresql.org (Tom Lane) |
|---|---|
| Тема | pgsql: Modify btree to delete known-dead index entries without an actual |
| Дата | |
| Msg-id | 20060725191300.AC08D9FA65C@postgresql.org обсуждение исходный текст |
| Список | 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)
В списке pgsql-committers по дате отправления: