diff options
| author | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2013-02-11 22:50:15 +0200 |
|---|---|---|
| committer | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2013-02-11 23:07:09 +0200 |
| commit | 62401db45c4feff9be296fa78a8bb7b9947d69de (patch) | |
| tree | 5d572267b5a2eae75049ba720bc1faf9f6a6694d /doc/src | |
| parent | b669f416cee77ef9025b80f9c4201688578447d1 (diff) | |
| download | postgresql-62401db45c4feff9be296fa78a8bb7b9947d69de.tar.gz postgresql-62401db45c4feff9be296fa78a8bb7b9947d69de.zip | |
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.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 8872920446a..af11eb05a65 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -182,8 +182,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI automatically truncated after a crash or unclean shutdown. The contents of an unlogged table are also not replicated to standby servers. Any indexes created on an unlogged table are automatically unlogged as - well; however, unlogged <link linkend="GiST">GiST indexes</link> are - currently not supported and cannot be created on an unlogged table. + well. </para> </listitem> </varlistentry> |