Request a Demo
Home   >   mailing lists

Re: 8.4 open item: copy performance regression? - Mailing list pgsql-hackers

From Alan Li
Subject Re: 8.4 open item: copy performance regression?
Date
Msg-id 782056770906212342n2e04c3b7k5987b6e59a1f8374@mail.gmail.com
Whole thread Raw
In response to Re: 8.4 open item: copy performance regression?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 8.4 open item: copy performance regression?
List pgsql-hackers
Tree view
Hi Tom,

How much concern is there for the contention for use cases where the WAL can't be bypassed?

Thanks, Alan

On Sun, Jun 21, 2009 at 10:00 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
> The following copying 3M rows(each) into a seperate table of the same
> database.

Is this with WAL, or bypassing WAL?  Given what we've already seen,
a lot of contention for WALInsertLock wouldn't surprise me much here.
It should be possible to bypass that though.

                       regards, tom lane



pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: rc tarball built with older flex version?
Next
From: Peter Eisentraut
Date:
Subject: Re: Missing Docs for MOVE direction?