[Bizgres-general] WAL bypass for CTAS
Luke Lonergan
llonergan at greenplum.com
Mon Jun 6 05:56:59 GMT 2005
Simon,
I've ported your WAL bypass patch for CREATE TABLE AS SELECT (CTAS) in
addition to your COPY prep patch that also bypasses WAL to postgres 8.0.2
(attached).
I ran a couple of tests, both on CTAS and on COPY and found no WAL bypass
occurred (size of XLOG directory is same as data directory). Since your
patches only allow WAL bypass when not in "Archive mode" aka PITR, or when
XLogArchivingActive() is false, when is that exactly? Under what conditions
will we not be in PITR mode?
Looking for a simple way to trigger the expected behavior.
Luke
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ctas-ported-8.0.patch
Type: application/octet-stream
Size: 16462 bytes
Desc: not available
Url : http://pgfoundry.org/pipermail/bizgres-general/attachments/20050606/dbfc977e/ctas-ported-8.0.obj
-------------- next part --------------
A non-text attachment was scrubbed...
Name: copywal_bypass-ported-8.0.patch
Type: application/octet-stream
Size: 2186 bytes
Desc: not available
Url : http://pgfoundry.org/pipermail/bizgres-general/attachments/20050606/dbfc977e/copywal_bypass-ported-8.0.obj
More information about the Bizgres-general
mailing list