Re: skip WAL on COPY patch - Mailing list pgsql-hackers

From Tom Lane
Subject Re: skip WAL on COPY patch
Date
Msg-id 1739.1314126320@sss.pgh.pa.us
Whole thread Raw
In response to skip WAL on COPY patch  (Steve Singer <ssinger@ca.afilias.info>)
Responses Re: skip WAL on COPY patch
Re: skip WAL on COPY patch
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: text search: restricting the number of parsed words in headline generation
Next
From: Dimitri Fontaine
Date:
Subject: Re: Getting rid of pg_pltemplate