• Kevin Grittner's avatar
    Fix hash index vs "snapshot too old" problemms · 2cc41acd
    Kevin Grittner authored
    Hash indexes are not WAL-logged, and so do not maintain the LSN of
    index pages.  Since the "snapshot too old" feature counts on
    detecting error conditions using the LSN of a table and all indexes
    on it, this makes it impossible to safely do early vacuuming on any
    table with a hash index, so add this to the tests for whether the
    xid used to vacuum a table can be adjusted based on
    old_snapshot_threshold.
    
    While at it, add a paragraph to the docs for old_snapshot_threshold
    which specifically mentions this and other aspects of the feature
    which may otherwise surprise users.
    
    Problem reported and patch reviewed by Amit Kapila
    2cc41acd
snapmgr.c 59.7 KB