Simon Riggs wrote: > I enclose a complete patch for avoiding WAL usage for CREATE TABLE AS > SELECT, when not in archive mode (PITR). The main use case for this is > large BI environments that create summary tables or prejoined tables, > though there are many general applications. > > There is no user interface for this. The speed gain is automatic, when > archiving is not enabled.
Could we do your NOLOGGING automatically in COPY if we test to see if anyone else is connected to our current database? I would _love_ to see pg_dump loads use this automatically, without having to add clauses to pg_dump output. I think we decided we can't do it automatically for all zero-row COPYs because of locking concerns. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])