• Simon Riggs's avatar
    COPY FREEZE and mark committed on fresh tables. · 8de72b66
    Simon Riggs authored
    When a relfilenode is created in this subtransaction or
    a committed child transaction and it cannot otherwise
    be seen by our own process, mark tuples committed ahead
    of transaction commit for all COPY commands in same
    transaction. If FREEZE specified on COPY
    and pre-conditions met then rows will also be frozen.
    Both options designed to avoid revisiting rows after commit,
    increasing performance of subsequent commands after
    data load and upgrade. pg_restore changes later.
    
    Simon Riggs, review comments from Heikki Linnakangas, Noah Misch and design
    input from Tom Lane, Robert Haas and Kevin Grittner
    8de72b66
copy2.sql 4.81 KB