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?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi Tom,<br /><br />How much concern is there for the contention for use cases where the WAL can't be bypassed?<br /><br
/>Thanks,Alan<br /><br /><div class="gmail_quote">On Sun, Jun 21, 2009 at 10:00 AM, Tom Lane <span dir="ltr"><<a
href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>></span>wrote:<br /><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">Stefan
Kaltenbrunner<stefan@kaltenbrunner.cc> writes:<br /></div><div class="im">> The following copying 3M
rows(each)into a seperate table of the same<br /> > database.<br /><br /></div>Is this with WAL, or bypassing WAL?
 Givenwhat we've already seen,<br /> a lot of contention for WALInsertLock wouldn't surprise me much here.<br /> It
shouldbe possible to bypass that though.<br /><br />                        regards, tom lane<br /><br /><br
/></blockquote></div><br/> 

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?