Re: skip WAL on COPY patch

Steve Singer <ssinger@ca.afilias.info> writes:
> The attached patch adds an option to the COPY command to skip writing 
> WAL when the following conditions are all met:

> 1) The table is empty (zero size on disk)
> 2) The copy command can obtain an access exclusive lock on the table 
> with out blocking.
> 3) The WAL isn't needed for replication

Exposing this as a user-visible option seems a seriously bad idea.
We'd have to support that forever.  ISTM it ought to be possible to
avoid the exclusive lock ... maybe not with this particular
implementation, but somehow.
        regards, tom lane