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

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: <pgsql-committers(at)postgresql(dot)org>, "Tom Lane" <tgl(at)postgresql(dot)org>
Subject: Re: pgsql-server/src backend/access/nbtree/Makefil ...
Date: 2003-02-21 02:13:52
Message-ID: 088f01c2d94e$e160a900$6500a8c0@fhp.internal
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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(at)postgresql(dot)org>
To: <pgsql-committers(at)postgresql(dot)org>
Sent: Friday, February 21, 2003 8:06 AM
Subject: [COMMITTERS] pgsql-server/src backend/access/nbtree/Makefil ...

> CVSROOT: /cvsroot
> Module name: pgsql-server
> Changes by: tgl(at)postgresql(dot)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
>

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2003-02-21 03:25:26 Re: pgsql-server/src backend/access/nbtree/Makefil ...
Previous Message Tom Lane 2003-02-21 00:06:22 pgsql-server/src backend/access/nbtree/Makefil ...