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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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)

Browse pgsql-committers by date

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