[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] Having some problems with concurrent COPY commands
From:       David Rowley <david.rowley () 2ndquadrant ! com>
Date:       2015-10-13 21:44:28
Message-ID: CAKJS1f8hD3Yb=5NGd=u0PkSqBanNdYKw_WJPPdF=PCLNfuLyiA () mail ! gmail ! com
[Download RAW message or body]

On 14 October 2015 at 08:33, Shaun Thomas <bonesmoses@gmail.com> wrote:

> On Tue, Oct 13, 2015 at 7:23 AM, Andres Freund <andres@anarazel.de> wrote:
> > and send the results.
>
> Whelp, I'm an idiot. I can't account for how I did it, but I can only
> assume I didn't export my ports in the tests properly. I ran
> everything again and there's a marked difference between 9.3 and 9.4.
> The parallel copy times still inflate, but only from 1.4s to 2.5s at 4
> procs. Though it gets a bit dicey after that.
>
>
>
Do the times still inflate in the same way if you perform the COPY before
adding the indexes to the table?

--
 David Rowley                   http://www.2ndQuadrant.com/
<http://www.2ndquadrant.com/>
 PostgreSQL Development, 24x7 Support, Training & Services

[Attachment #3 (text/html)]

<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On 14 October 2015 \
at 08:33, Shaun Thomas <span dir="ltr">&lt;<a href="mailto:bonesmoses@gmail.com" \
target="_blank">bonesmoses@gmail.com</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">On Tue, Oct 13, 2015 at 7:23 AM, Andres Freund &lt;<a \
href="mailto:andres@anarazel.de">andres@anarazel.de</a>&gt; wrote:<br> &gt; and send \
the results.<br> <br>
Whelp, I&#39;m an idiot. I can&#39;t account for how I did it, but I can only<br>
assume I didn&#39;t export my ports in the tests properly. I ran<br>
everything again and there&#39;s a marked difference between 9.3 and 9.4.<br>
The parallel copy times still inflate, but only from 1.4s to 2.5s at 4<br>
procs. Though it gets a bit dicey after that.<br>
<br><div class="HOEnZb"><div class="h5"><br></div></div></blockquote></div><div \
class="gmail_extra"><br></div>Do the times still inflate in the same way if you \
perform the COPY before adding the indexes to the table?<br \
clear="all"><div><br></div><div><span \
style="color:rgb(136,136,136);font-size:12.8px">--</span><br></div><div \
class="gmail_signature"><div dir="ltr"><span \
style="font-size:12.8000001907349px"><font color="#888888">  David Rowley             \
<a href="http://www.2ndquadrant.com/" style="color:rgb(17,85,204)" \
target="_blank">http://www.2ndQuadrant.com/</a><br></font></span><div \
style="font-size:12.8000001907349px"><div></div><div>  PostgreSQL Development, 24x7 \
Support, Training &amp; Services</div></div></div></div> </div></div>



[prev in list] [next in list] [prev in thread] [next in thread]