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

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

From

tgl@svr1.postgresql.org (Tom Lane)

Date:

20 June 2005, 15:37:06

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)