pgsql: Remove the 'slow' path for btree index build, which built the

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Remove the 'slow' path for btree index build, which built the
Date: 2006-04-01 03:03:37
Message-ID: 20060401030337.DA74711F61BF@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Remove the 'slow' path for btree index build, which built the btree
incrementally by successive inserts rather than by sorting the data.
We were only using the slow path during bootstrap, apparently because
when first written it failed during bootstrap --- but it works fine now
AFAICT. Removing it saves a hundred or so lines of code and produces
noticeably (~10%) smaller initial states of the system catalog indexes.
While that won't make much difference for heavily-modified catalogs,
for the more static ones there may be a useful long-term performance
improvement.

Modified Files:
--------------
pgsql/src/backend/access/nbtree:
nbtpage.c (r1.94 -> r1.95)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/nbtree/nbtpage.c.diff?r1=1.94&r2=1.95)
nbtree.c (r1.143 -> r1.144)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/nbtree/nbtree.c.diff?r1=1.143&r2=1.144)
nbtxlog.c (r1.30 -> r1.31)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/nbtree/nbtxlog.c.diff?r1=1.30&r2=1.31)
pgsql/src/include/access:
nbtree.h (r1.94 -> r1.95)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/access/nbtree.h.diff?r1=1.94&r2=1.95)

Browse pgsql-committers by date

  From Date Subject
Next Message User Llonergan 2006-04-01 05:40:14 bizgres - bizgres: Fix the CVS tag insertion.
Previous Message User Nwakefield 2006-04-01 02:42:47 bizgres - bizgres: Parameter inheritance was inconsistent across job