Обсуждение: pgsql: Support unlogged GiST index.

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

pgsql: Support unlogged GiST index.

От
Heikki Linnakangas
Дата:
Support unlogged GiST index.

The reason this wasn't supported before was that GiST indexes need an
increasing sequence to detect concurrent page-splits. In a regular WAL-
logged GiST index, the LSN of the page-split record is used for that
purpose, and in a temporary index, we can get away with a backend-local
counter. Neither of those methods works for an unlogged relation.

To provide such an increasing sequence of numbers, create a "fake LSN"
counter that is saved and restored across shutdowns. On recovery, unlogged
relations are blown away, so the counter doesn't need to survive that
either.

Jeevan Chalke, based on discussions with Robert Haas, Tom Lane and me.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/62401db45c4feff9be296fa78a8bb7b9947d69de

Modified Files
--------------
doc/src/sgml/ref/create_table.sgml      |    3 +-
src/backend/access/gist/gist.c          |   24 +++++++++++---
src/backend/access/gist/gistbuild.c     |   12 +-------
src/backend/access/gist/gistutil.c      |   30 +++++++++++++-----
src/backend/access/gist/gistvacuum.c    |    2 +-
src/backend/access/transam/xlog.c       |   51 +++++++++++++++++++++++++++++++
src/backend/storage/buffer/bufmgr.c     |   19 ++++++++++-
src/bin/pg_controldata/pg_controldata.c |    3 ++
src/bin/pg_resetxlog/pg_resetxlog.c     |    1 +
src/include/access/gist_private.h       |    2 +-
src/include/access/xlog.h               |    1 +
src/include/catalog/pg_control.h        |    4 ++-
12 files changed, 121 insertions(+), 31 deletions(-)