Skip site navigation (1) Skip section navigation (2)

pgsql: COPY FREEZE and mark committed on fresh tables.

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: COPY FREEZE and mark committed on fresh tables.
Date: 2012-12-01 12:57:24
Message-ID: (view raw or whole thread)
Lists: pgsql-committers
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



Modified Files
doc/src/sgml/ref/copy.sgml          |   23 ++++++++
src/backend/access/heap/heapam.c    |   17 +++++-
src/backend/commands/copy.c         |   33 +++++++++++
src/backend/parser/gram.y           |    4 +
src/backend/utils/mmgr/portalmem.c  |   19 ++++++
src/backend/utils/time/snapmgr.c    |    9 +++
src/include/access/heapam.h         |    2 +
src/include/utils/portal.h          |    1 +
src/include/utils/snapmgr.h         |    1 +
src/test/regress/expected/copy2.out |  106 +++++++++++++++++++++++++++++++++++
src/test/regress/sql/copy2.sql      |   78 +++++++++++++++++++++++++
11 files changed, 292 insertions(+), 1 deletions(-)


pgsql-committers by date

Next:From: Andrew DunstanDate: 2012-12-01 13:36:01
Subject: Re: pgsql: COPY FREEZE and mark committed on fresh tables.
Previous:From: Peter EisentrautDate: 2012-12-01 06:56:13
Subject: pgsql: doc: Fix broken links to DocBook wiki

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group