Обсуждение: pgsql: Remove the 'slow' path for btree index build, which built the

Поиск
Список
Период
Сортировка

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

От
tgl@postgresql.org (Tom Lane)
Дата:
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)