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

pgsql: Avoid WAL-logging individual tuple insertions during CREATE TABLE

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Avoid WAL-logging individual tuple insertions during CREATE TABLE
Date: 2005-06-20 18:37:02
Message-ID: 20050620183702.AB0A7528E7@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Avoid WAL-logging individual tuple insertions during CREATE TABLE AS
(a/k/a SELECT INTO).  Instead, flush and fsync the whole relation before
committing.  We do still need the WAL log when PITR is active, however.
Simon Riggs and Tom Lane.

Modified Files:
--------------
    pgsql/src/backend/access/heap:
        heapam.c (r1.194 -> r1.195)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/heapam.c.diff?r1=1.194&r2=1.195)
        hio.c (r1.56 -> r1.57)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/hio.c.diff?r1=1.56&r2=1.57)
    pgsql/src/backend/executor:
        execMain.c (r1.249 -> r1.250)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execMain.c.diff?r1=1.249&r2=1.250)
        execUtils.c (r1.123 -> r1.124)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execUtils.c.diff?r1=1.123&r2=1.124)
    pgsql/src/backend/storage/smgr:
        md.c (r1.115 -> r1.116)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/smgr/md.c.diff?r1=1.115&r2=1.116)
        smgr.c (r1.90 -> r1.91)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/smgr/smgr.c.diff?r1=1.90&r2=1.91)
    pgsql/src/include/access:
        heapam.h (r1.101 -> r1.102)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/access/heapam.h.diff?r1=1.101&r2=1.102)
        hio.h (r1.27 -> r1.28)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/access/hio.h.diff?r1=1.27&r2=1.28)
    pgsql/src/include/nodes:
        execnodes.h (r1.134 -> r1.135)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/execnodes.h.diff?r1=1.134&r2=1.135)

pgsql-committers by date

Next:From: James William PyeDate: 2005-06-20 19:30:54
Subject: python - lo: Don't try to resolve the path.
Previous:From: User DiogobDate: 2005-06-20 17:00:50
Subject: dblink-tds - dblink_tds: changes to make version compatible with 7.4.x

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