Re: effective_io_concurrency on EBS/gp2

From: hzzhangjiazhi <hzzhangjiazhi(at)corp(dot)netease(dot)com>
To: Vitaliy Garnashevich <vgarnashevich(at)gmail(dot)com>
Cc: Claudio Freire <klaussfreire(at)gmail(dot)com>, Gary Doades <gpd(at)gpdnet(dot)co(dot)uk>, Rick Otten <rottenwindfish(at)gmail(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: effective_io_concurrency on EBS/gp2
Date: 2018-02-01 02:21:28
Message-ID: 9122FC8B-2129-4E10-807F-F9F34117A156@corp.netease.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

<html>
<head>
<meta http-equiv='Content-Type' content='text/html; charset=UTF-8'>
</head>
<body>
<style>
*{
margin: 0;
padding: 0;
}
font{
line-height: 1.6;
}
ul,ol{
padding-left: 20px;
list-style-position: inside;
}
</style>
<div style = 'font-family:"微软雅黑"; line-height:1.6;'>
<div>
<div><span>HI&nbsp;</span></div><div><span><br></span></div><div><span>&nbsp; &nbsp; &nbsp;I think this parameter will be usefull when the storage using RAID stripe , otherwise turn up this parameter is meaningless when only has one device。</span></div>
<div><span><br></span></div>
<div><span><br></span></div>
<div id="ntes-pcmail-signature" style="font-family:'微软雅黑'">
<style type="text/css">
a#ntes-pcmail-signature-default:hover {
text-decoration: underline;
color: #199cff;
cursor: pointer;
}
a#ntes-pcmail-signature-default:active {
text-decoration: underline;
color: #246fce;
cursor: pointer;
}
</style>

<font style="padding: 0; margin:0;">
<div id="ntes-pcmail-signature-default" style="font-size:14px; color:#000; text-decoration: none;">发自网易邮箱大师</div> </font>

</div></div><div class="J-reply" style="background-color:#f2f2f2;color:black;padding-top:6px;padding-bottom:6px;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;margin-top:45px;margin-bottom:20px;font-family:'微软雅黑';">
<div style="font-size:12px;line-height:1.5;word-break:break-all;margin-left:10px;margin-right:10px">On <span class="mail-date">2/1/2018 04:29</span>，<a class="mail-to" style="text-decoration:none;color:#2a83f2;" href="mailto:vgarnashevich(at)gmail(dot)com">Vitaliy Garnashevich&lt;vgarnashevich(at)gmail(dot)com&gt;</a> wrote： </div>
</div>
<blockquote id="ntes-pcmail-quote" style="margin: 0; padding: 0; font-size: 14px; font-family: '微软雅黑';">
I've done some more tests. Here they are all:<br><br>io1, 100 GB SSD, 1000 IOPS<br>effective_io_concurrency=0 Execution time: 40333.626 ms<br>effective_io_concurrency=1 Execution time: 163840.500 ms<br>effective_io_concurrency=2 Execution time: 162606.330 ms<br>effective_io_concurrency=4 Execution time: 163670.405 ms<br>effective_io_concurrency=8 Execution time: 161800.478 ms<br>effective_io_concurrency=16 Execution time: 161962.319 ms<br>effective_io_concurrency=32 Execution time: 160451.435 ms<br>effective_io_concurrency=64 Execution time: 161763.632 ms<br>effective_io_concurrency=128 Execution time: 161687.398 ms<br>effective_io_concurrency=256 Execution time: 160945.066 ms<br>effective_io_concurrency=256 Execution time: 161226.440 ms<br>effective_io_concurrency=128 Execution time: 161977.954 ms<br>effective_io_concurrency=64 Execution time: 159122.006 ms<br>effective_io_concurrency=32 Execution time: 154923.569 ms<br>effective_io_concurrency=16 Execution time: 160922.819 ms<br>effective_io_concurrency=8 Execution time: 160577.122 ms<br>effective_io_concurrency=4 Execution time: 157509.481 ms<br>effective_io_concurrency=2 Execution time: 161806.713 ms<br>effective_io_concurrency=1 Execution time: 164026.708 ms<br>effective_io_concurrency=0 Execution time: 40196.182 ms<br><br>gp2, 100 GB SSD<br>effective_io_concurrency=0 Execution time: 40262.781 ms<br>effective_io_concurrency=1 Execution time: 98125.987 ms<br>effective_io_concurrency=2 Execution time: 55343.776 ms<br>effective_io_concurrency=4 Execution time: 52505.638 ms<br>effective_io_concurrency=8 Execution time: 54954.024 ms<br>effective_io_concurrency=16 Execution time: 54346.455 ms<br>effective_io_concurrency=32 Execution time: 55196.626 ms<br>effective_io_concurrency=64 Execution time: 55057.956 ms<br>effective_io_concurrency=128 Execution time: 54963.510 ms<br>effective_io_concurrency=256 Execution time: 54339.258 ms<br><br>io1, 1 TB SSD, 3000 IOPS<br>effective_io_concurrency=0 Execution time: 40691.396 ms<br>effective_io_concurrency=1 Execution time: 87524.939 ms<br>effective_io_concurrency=2 Execution time: 54197.982 ms<br>effective_io_concurrency=4 Execution time: 55082.740 ms<br>effective_io_concurrency=8 Execution time: 54838.161 ms<br>effective_io_concurrency=16 Execution time: 52561.553 ms<br>effective_io_concurrency=32 Execution time: 54266.847 ms<br>effective_io_concurrency=64 Execution time: 54683.102 ms<br>effective_io_concurrency=128 Execution time: 54643.874 ms<br>effective_io_concurrency=256 Execution time: 42944.938 ms<br><br>gp2, 1 TB SSD<br>effective_io_concurrency=0 Execution time: 40072.880 ms<br>effective_io_concurrency=1 Execution time: 83528.679 ms<br>effective_io_concurrency=2 Execution time: 55706.941 ms<br>effective_io_concurrency=4 Execution time: 55664.646 ms<br>effective_io_concurrency=8 Execution time: 54699.658 ms<br>effective_io_concurrency=16 Execution time: 54632.291 ms<br>effective_io_concurrency=32 Execution time: 54793.305 ms<br>effective_io_concurrency=64 Execution time: 55227.875 ms<br>effective_io_concurrency=128 Execution time: 54638.744 ms<br>effective_io_concurrency=256 Execution time: 54869.761 ms<br><br>st1, 500 GB HDD<br>effective_io_concurrency=0 Execution time: 40542.583 ms<br>effective_io_concurrency=1 Execution time: 119996.892 ms<br>effective_io_concurrency=2 Execution time: 51137.998 ms<br>effective_io_concurrency=4 Execution time: 42301.922 ms<br>effective_io_concurrency=8 Execution time: 42081.877 ms<br>effective_io_concurrency=16 Execution time: 42253.782 ms<br>effective_io_concurrency=32 Execution time: 42087.216 ms<br>effective_io_concurrency=64 Execution time: 42112.105 ms<br>effective_io_concurrency=128 Execution time: 42271.850 ms<br>effective_io_concurrency=256 Execution time: 42213.074 ms<br><br>Regards,<br>Vitaliy<br><br></blockquote><!--😀-->
</div>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 5.8 KB

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message pavan95 2018-02-01 06:18:00 Re: 8.2 Autovacuum BUG ?
Previous Message Jeff Janes 2018-01-31 21:00:46 Re: effective_io_concurrency on EBS/gp2