| From: | momjian(at)postgresql(dot)org (Bruce Momjian) |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Reduce WAL activity for page splits: > Currently, an index split |
| Date: | 2007-02-08 05:05:54 |
| Message-ID: | 20070208050554.1ED249FB373@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan Kaltenbrunner | 2007-02-08 08:31:28 | Re: [COMMITTERS] pgsql: Reduce WAL activity for page splits: > Currently, an index split |
| Previous Message | Bruce Momjian | 2007-02-08 04:52:19 | pgsql: Check if the role exists before doing more complex ident and |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan Kaltenbrunner | 2007-02-08 08:31:28 | Re: [COMMITTERS] pgsql: Reduce WAL activity for page splits: > Currently, an index split |
| Previous Message | Bruce Momjian | 2007-02-08 04:52:28 | Re: [HACKERS] elog(FATAL)ing non-existent roles during client |