pgsql-server/src backend/access/nbtree/Makefil ...

Started by Tom Laneover 23 years ago3 messagescomitters
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: tgl@postgresql.org 03/02/20 19:06:22

Modified files:
src/backend/access/nbtree: Makefile README nbtinsert.c nbtpage.c
nbtree.c nbtsearch.c nbtsort.c
src/backend/access/transam: rmgr.c xlog.c
src/include/access: nbtree.h xlog.h
src/include/catalog: catversion.h
Added files:
src/backend/access/nbtree: nbtxlog.c

Log message:
Make btree index structure adjustments and WAL logging changes needed to
support btree compaction, as per proposal of a few days ago. btree index
pages no longer store parent links, instead they have a level indicator
(counting up from zero for leaf pages). The FixBTree recovery logic is
removed, and replaced by code that detects missing parent-level insertions
during WAL replay. Also, generate appropriate WAL entries when updating
btree metapage and when building a btree index from scratch. I believe
btree indexes are now completely WAL-legal for the first time.
initdb forced due to index and WAL changes.

#2Christopher Kings-Lynne
chriskl@familyhealth.com.au
In reply to: Tom Lane (#1)
Re: pgsql-server/src backend/access/nbtree/Makefil ...

Does this mean that btrees no longer need regular reindexing? Or is there
more work to be done?

Chris

----- Original Message -----
From: "Tom Lane" <tgl@postgresql.org>
To: <pgsql-committers@postgresql.org>
Sent: Friday, February 21, 2003 8:06 AM
Subject: [COMMITTERS] pgsql-server/src backend/access/nbtree/Makefil ...

Show quoted text

CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: tgl@postgresql.org 03/02/20 19:06:22

Modified files:
src/backend/access/nbtree: Makefile README nbtinsert.c nbtpage.c
nbtree.c nbtsearch.c nbtsort.c
src/backend/access/transam: rmgr.c xlog.c
src/include/access: nbtree.h xlog.h
src/include/catalog: catversion.h
Added files:
src/backend/access/nbtree: nbtxlog.c

Log message:
Make btree index structure adjustments and WAL logging changes needed to
support btree compaction, as per proposal of a few days ago. btree index
pages no longer store parent links, instead they have a level indicator
(counting up from zero for leaf pages). The FixBTree recovery logic is
removed, and replaced by code that detects missing parent-level insertions
during WAL replay. Also, generate appropriate WAL entries when updating
btree metapage and when building a btree index from scratch. I believe
btree indexes are now completely WAL-legal for the first time.
initdb forced due to index and WAL changes.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Christopher Kings-Lynne (#2)
Re: pgsql-server/src backend/access/nbtree/Makefil ...

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:

Does this mean that btrees no longer need regular reindexing? Or is there
more work to be done?

This is only the first step...

regards, tom lane