• Kevin Grittner's avatar
    Fix interaction between CREATE INDEX and "snapshot too old". · bf9a60ee
    Kevin Grittner authored
    Since indexes are created without valid LSNs, an index created
    while a snapshot older than old_snapshot_threshold existed could
    cause queries to return incorrect results when those old snapshots
    were used, if any relevant rows had been subject to early pruning
    before the index was built.  Prevent usage of a newly created index
    until all such snapshots are released, for relations where this can
    happen.
    
    Questions about the interaction of "snapshot too old" with index
    creation were initially raised by Andres Freund.
    
    Reviewed by Robert Haas.
    bf9a60ee
snapmgr.h 3.98 KB