Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: 8.4 open item: copy performance regression?
Date
Msg-id 14771.1245603609@sss.pgh.pa.us
Whole thread Raw
In response to Re: 8.4 open item: copy performance regression?  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Responses Re: 8.4 open item: copy performance regression?  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Re: 8.4 open item: copy performance regression?  (Alan Li <ali@truviso.com>)
List pgsql-hackers
Tree view 
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: Stefan Kaltenbrunner
Date:
Subject: Re: 8.4 open item: copy performance regression?
Next
From: Gurjeet Singh
Date:
Subject: Re: Suppressing occasional failures in copy2 regression test