[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