COPY FREEZE and mark committed on fresh tables.
authorSimon Riggs <simon@2ndQuadrant.com>
Sat, 1 Dec 2012 12:54:20 +0000 (12:54 +0000)
committerSimon Riggs <simon@2ndQuadrant.com>
Sat, 1 Dec 2012 12:54:20 +0000 (12:54 +0000)
commit8de72b66a2edcf12c812de0a73bd50b6b7d81d62
tree3cb4fc55c3d70b7b972910cfeb22cbb7c704875a
parent44c03efee3d15a1db3d64bc5a2da91c145a91873
COPY FREEZE and mark committed on fresh tables.
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
doc/src/sgml/ref/copy.sgml
src/backend/access/heap/heapam.c
src/backend/commands/copy.c
src/backend/parser/gram.y
src/backend/utils/mmgr/portalmem.c
src/backend/utils/time/snapmgr.c
src/include/access/heapam.h
src/include/utils/portal.h
src/include/utils/snapmgr.h
src/test/regress/expected/copy2.out
src/test/regress/sql/copy2.sql