diff options
| author | Robert Haas | 2017-03-14 17:27:02 +0000 |
|---|---|---|
| committer | Robert Haas | 2017-03-14 17:27:02 +0000 |
| commit | c11453ce0aeaa377cbbcc9a3fc418acb94629330 (patch) | |
| tree | b7e0c1952bd7167ce826b8ed4bf8204012f4a47b /contrib | |
| parent | 2b32ac2a59df18246c3b79e96a209bfdb39bb918 (diff) | |
hash: Add write-ahead logging support.
The warning about hash indexes not being write-ahead logged and their
use being discouraged has been removed. "snapshot too old" is now
supported for tables with hash indexes. Most importantly, barring
bugs, hash indexes will now be crash-safe and usable on standbys.
This commit doesn't yet add WAL consistency checking for hash
indexes, as we now have for other index types; a separate patch has
been submitted to cure that lack.
Amit Kapila, reviewed and slightly modified by me. The larger patch
series of which this is a part has been reviewed and tested by Álvaro
Herrera, Ashutosh Sharma, Mark Kirkwood, Jeff Janes, and Jesper
Pedersen.
Discussion: http://postgr.es/m/CAA4eK1JOBX=YU33631Qh-XivYXtPSALh514+jR8XeD7v+K3r_Q@mail.gmail.com
Diffstat (limited to 'contrib')
| -rw-r--r-- | contrib/pageinspect/expected/hash.out | 1 | ||||
| -rw-r--r-- | contrib/pgstattuple/expected/pgstattuple.out | 2 |
2 files changed, 0 insertions, 3 deletions
diff --git a/contrib/pageinspect/expected/hash.out b/contrib/pageinspect/expected/hash.out index 8ed60bccc0d..3ba01f6ca36 100644 --- a/contrib/pageinspect/expected/hash.out +++ b/contrib/pageinspect/expected/hash.out @@ -1,7 +1,6 @@ CREATE TABLE test_hash (a int, b text); INSERT INTO test_hash VALUES (1, 'one'); CREATE INDEX test_hash_a_idx ON test_hash USING hash (a); -WARNING: hash indexes are not WAL-logged and their use is discouraged \x SELECT hash_page_type(get_raw_page('test_hash_a_idx', 0)); -[ RECORD 1 ]--+--------- diff --git a/contrib/pgstattuple/expected/pgstattuple.out b/contrib/pgstattuple/expected/pgstattuple.out index baee2bd96ec..2c3515b4eff 100644 --- a/contrib/pgstattuple/expected/pgstattuple.out +++ b/contrib/pgstattuple/expected/pgstattuple.out @@ -131,7 +131,6 @@ select * from pgstatginindex('test_ginidx'); (1 row) create index test_hashidx on test using hash (b); -WARNING: hash indexes are not WAL-logged and their use is discouraged select * from pgstathashindex('test_hashidx'); version | bucket_pages | overflow_pages | bitmap_pages | zero_pages | live_items | dead_items | free_percent ---------+--------------+----------------+--------------+------------+------------+------------+-------------- @@ -226,7 +225,6 @@ ERROR: "test_partition" is not an index -- an actual index of a partitioned table should work though create index test_partition_idx on test_partition(a); create index test_partition_hash_idx on test_partition using hash (a); -WARNING: hash indexes are not WAL-logged and their use is discouraged -- these should work select pgstatindex('test_partition_idx'); pgstatindex |