Re: skip WAL on COPY patch

On Tue, 2011-08-23 at 15:05 -0400, Tom Lane wrote:
> 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.

In that particular way, I agree. But it might be useful if there were a
more general declarative option like "BULKLOAD". We might then use that
information for a number of optimizations that make sense for large
loads.

Regards,Jeff Davis