Greg Stark <[EMAIL PROTECTED]> writes: > For CREATE TABLE AS in the non-PITR case you don't really need to WAL log the > records at all. If it fails in the middle you just drop the table. When it > completes you do a checkpoint before acknowledging the COMMIT. > > I think this is already done for CREATE INDEX/REINDEX, also only in the > non-PITR case.
Sorry to followup to my own message, but it occurs to me that COPY could be made to automatically do this for the case of an empty destination table too. I'm not sure if it should automatically check for an empty table or if there should be an option for the user to indicate he wants COPY to replace the current contents entirely. The latter might actually be more useful. . But either way, you just WAL log a record indicating that the table should be entirely empty. Then you fill it up without logging anything. Do a checkpoint and then WAL log that the COPY is finished. If any failure occurs replay leaves it empty. Again this sadly only works in the non-PITR case. -- greg ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
