Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Reduce WAL activity for page splits: > Currently, an index split - Mailing list pgsql-committers

From momjian@postgresql.org (Bruce Momjian)
Subject pgsql: Reduce WAL activity for page splits: > Currently, an index split
Date
Msg-id 20070208050554.1ED249FB373@postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
Log Message:
-----------
Reduce WAL activity for page splits:

> Currently, an index split writes all the data on the split page to
> WAL. That's a lot of WAL traffic. The tuples that are copied to the
> right page need to be WAL logged, but the tuples that stay on the
> original page don't.

Heikki Linnakangas

Modified Files:
--------------
    pgsql/src/backend/access/nbtree:
        nbtinsert.c (r1.149 -> r1.150)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/nbtree/nbtinsert.c.diff?r1=1.149&r2=1.150)
        nbtxlog.c (r1.41 -> r1.42)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/nbtree/nbtxlog.c.diff?r1=1.41&r2=1.42)
    pgsql/src/include/access:
        nbtree.h (r1.110 -> r1.111)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/access/nbtree.h.diff?r1=1.110&r2=1.111)

pgsql-committers by date:

Previous
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Check if the role exists before doing more complex ident and
Next
From: petere@postgresql.org (Peter Eisentraut)
Date:
Subject: pgsql: Normalize fgets() calls to use sizeof() for calculating the