Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1egz0R-0001Md-5g for pgsql-performance@arkaria.postgresql.org; Wed, 31 Jan 2018 20:29:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1egz0P-0004B3-Sf for pgsql-performance@arkaria.postgresql.org; Wed, 31 Jan 2018 20:29:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1egz0P-0004At-Ii for pgsql-performance@lists.postgresql.org; Wed, 31 Jan 2018 20:29:17 +0000 Received: from mail-yw0-x22e.google.com ([2607:f8b0:4002:c05::22e]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1egz0M-0007vt-M2 for pgsql-performance@lists.postgresql.org; Wed, 31 Jan 2018 20:29:17 +0000 Received: by mail-yw0-x22e.google.com with SMTP id b16so5772989ywh.12 for ; Wed, 31 Jan 2018 12:29:13 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding:content-language; bh=iDM2UbMIxjG8PuRiT0WAPVaTojd9Uy1P6lUuVMaSP6Q=; b=kSeBjR0qE7hR9tIJKWbJBjvPy4oVYG1E6n5PXKDJbj3vJKi0nngECjNvzxo/V2e+j+ T6vDFYl0bxEuIoEAnpWQ6Vtw2+pwcnSJtkB6GWesG8xbtkEbf9xFuxCUWUmwRJyw2EWu sX4M8tnMLeikHMuvW2VuGItpYCUjw84gYirtfs/FvAEzdZQRilEUtC6rkJdusPzKizsV plN5KBBxYZFpAKRqnl0cpwGftc0u5yPhLmf2DEjrWjNOZwTE8XTSGuRTotvZdPS9PCPi 0rONU4r9GulKoytMrcvuzU8sUSe1i3YIfpwddVBJwKDbeMLUtBX+X8K0Dw8NR3EDQQQF al8g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=iDM2UbMIxjG8PuRiT0WAPVaTojd9Uy1P6lUuVMaSP6Q=; b=e6sr3Q2VrBy0LYsdOgpZerXG/12/1G53WJNfNa0Iif0Adky1h9x/58KRlgngtq+oCi QJaTQF6Gs4PUJOpY/9JcXR+8g6zvS5sWiVC9gujVFtvQRaCkn2iAHNRWGMazNGUc7afu zkOjePLFf3wSOpXl1RQsN/5M3j/HMXK5a3T7PC6FX3J/Uuabu2+t9ck54J4aPmCxGXc4 SaXYSULBOlh91h/ILrBimYDvCpOit41lr9CbTrrx9jNRBZ0Ar/RPS23O1LXXm0MDOE7c TKRtGl5DywnnxW6hKdqk8eL/9+VseJO+yr3BET3Dd0x6WfknBFM+p64mVT+XQv3A7Vk4 yWsA== X-Gm-Message-State: AKwxytdQ+O6WJIuorxBPLGN5zO5I86xYXR7id6LrhNxZ1LJG2kas7Wuw TyYm4nIttaeLbUTsOeL2QoaQZN9t X-Google-Smtp-Source: AH8x227dbHAYQhtSEwgkQTMhZ2Ye/VIVzKoGAZfesTmBjSBNHXKnSOtA6BergQ1+6DTtLaSlcfR1OQ== X-Received: by 10.37.100.12 with SMTP id y12mr12918922ybb.241.1517430552193; Wed, 31 Jan 2018 12:29:12 -0800 (PST) Received: from [192.168.1.151] ([178.54.41.83]) by smtp.gmail.com with ESMTPSA id w5sm6461594ywl.89.2018.01.31.12.29.10 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 31 Jan 2018 12:29:11 -0800 (PST) Subject: Re: effective_io_concurrency on EBS/gp2 To: Claudio Freire Cc: Gary Doades , Rick Otten , pgsql-performance@lists.postgresql.org References: <6c7a45df-f6ab-f2ce-6f84-9555864f6c86@gmail.com> <768e3a56-46ed-3dd1-8722-953a47857a35@gmail.com> <014801d39a99$d4c32930$7e497b90$@gpdnet.co.uk> <8fb758a1-d7fa-4dcc-fb5b-07a992ae6a32@gmail.com> From: Vitaliy Garnashevich Message-ID: <534b557c-3658-6d0f-2330-34a78da57e2f@gmail.com> Date: Wed, 31 Jan 2018 22:29:09 +0200 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.5.2 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk I've done some more tests. Here they are all: io1, 100 GB SSD, 1000 IOPS effective_io_concurrency=0 Execution time: 40333.626 ms effective_io_concurrency=1 Execution time: 163840.500 ms effective_io_concurrency=2 Execution time: 162606.330 ms effective_io_concurrency=4 Execution time: 163670.405 ms effective_io_concurrency=8 Execution time: 161800.478 ms effective_io_concurrency=16 Execution time: 161962.319 ms effective_io_concurrency=32 Execution time: 160451.435 ms effective_io_concurrency=64 Execution time: 161763.632 ms effective_io_concurrency=128 Execution time: 161687.398 ms effective_io_concurrency=256 Execution time: 160945.066 ms effective_io_concurrency=256 Execution time: 161226.440 ms effective_io_concurrency=128 Execution time: 161977.954 ms effective_io_concurrency=64 Execution time: 159122.006 ms effective_io_concurrency=32 Execution time: 154923.569 ms effective_io_concurrency=16 Execution time: 160922.819 ms effective_io_concurrency=8 Execution time: 160577.122 ms effective_io_concurrency=4 Execution time: 157509.481 ms effective_io_concurrency=2 Execution time: 161806.713 ms effective_io_concurrency=1 Execution time: 164026.708 ms effective_io_concurrency=0 Execution time: 40196.182 ms gp2, 100 GB SSD effective_io_concurrency=0 Execution time: 40262.781 ms effective_io_concurrency=1 Execution time: 98125.987 ms effective_io_concurrency=2 Execution time: 55343.776 ms effective_io_concurrency=4 Execution time: 52505.638 ms effective_io_concurrency=8 Execution time: 54954.024 ms effective_io_concurrency=16 Execution time: 54346.455 ms effective_io_concurrency=32 Execution time: 55196.626 ms effective_io_concurrency=64 Execution time: 55057.956 ms effective_io_concurrency=128 Execution time: 54963.510 ms effective_io_concurrency=256 Execution time: 54339.258 ms io1, 1 TB SSD, 3000 IOPS effective_io_concurrency=0 Execution time: 40691.396 ms effective_io_concurrency=1 Execution time: 87524.939 ms effective_io_concurrency=2 Execution time: 54197.982 ms effective_io_concurrency=4 Execution time: 55082.740 ms effective_io_concurrency=8 Execution time: 54838.161 ms effective_io_concurrency=16 Execution time: 52561.553 ms effective_io_concurrency=32 Execution time: 54266.847 ms effective_io_concurrency=64 Execution time: 54683.102 ms effective_io_concurrency=128 Execution time: 54643.874 ms effective_io_concurrency=256 Execution time: 42944.938 ms gp2, 1 TB SSD effective_io_concurrency=0 Execution time: 40072.880 ms effective_io_concurrency=1 Execution time: 83528.679 ms effective_io_concurrency=2 Execution time: 55706.941 ms effective_io_concurrency=4 Execution time: 55664.646 ms effective_io_concurrency=8 Execution time: 54699.658 ms effective_io_concurrency=16 Execution time: 54632.291 ms effective_io_concurrency=32 Execution time: 54793.305 ms effective_io_concurrency=64 Execution time: 55227.875 ms effective_io_concurrency=128 Execution time: 54638.744 ms effective_io_concurrency=256 Execution time: 54869.761 ms st1, 500 GB HDD effective_io_concurrency=0 Execution time: 40542.583 ms effective_io_concurrency=1 Execution time: 119996.892 ms effective_io_concurrency=2 Execution time: 51137.998 ms effective_io_concurrency=4 Execution time: 42301.922 ms effective_io_concurrency=8 Execution time: 42081.877 ms effective_io_concurrency=16 Execution time: 42253.782 ms effective_io_concurrency=32 Execution time: 42087.216 ms effective_io_concurrency=64 Execution time: 42112.105 ms effective_io_concurrency=128 Execution time: 42271.850 ms effective_io_concurrency=256 Execution time: 42213.074 ms Regards, Vitaliy