On Mon, Jun 22, 2009 at 7:16 AM, Tom Lane
<tgl@sss.pgh.pa.us> wrote:
Alan Li <
ali@truviso.com> writes:
> How much concern is there for the contention for use cases where the WAL
> can't be bypassed?
answer is "no". This is a pre-existing issue that there is no simple
fix for.
regards, tom lane
No no, I am certainly not implying anything for the 8.4 timeframe.
Moving forward, I imagine this being more of a problem for data warehouse applications, where bulk inserts occur on existing fact tables. In this case, the WAL cannot be bypassed (unless the bulk insert occurs on a newly created partition). And since COPY is cpu-bound, it would perhaps be advantageous to do parallel COPY's on the same table on multi-core systems, which won't work with WAL bypassing either.
Thanks, Alan
