Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id E4B9BB5DBD1 for ; Mon, 3 Oct 2011 01:35:54 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 81527-01 for ; Mon, 3 Oct 2011 04:35:48 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.9]) by mail.postgresql.org (Postfix) with ESMTP id C6D49B5DBC0 for ; Mon, 3 Oct 2011 01:35:47 -0300 (ADT) Received: from [192.168.1.160] (bali.purnam.com [75.144.245.226]) by mrelayeu.kundenserver.de (node=mreu3) with ESMTP (Nemesis) id 0MJIXG-1R8vIQ3aZO-002O9g; Mon, 03 Oct 2011 06:35:45 +0200 Message-ID: <4E893B9F.1070300@2ndQuadrant.com> Date: Sun, 02 Oct 2011 21:35:43 -0700 From: Greg Smith User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.16) Gecko/20110818 Icedove/3.0.11 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Suggestions for Intel 710 SSD test References: <4E87CEDF.3000504@boreham.org> In-Reply-To: <4E87CEDF.3000504@boreham.org> Content-Type: multipart/mixed; boundary="------------010001010903040006030005" X-Provags-ID: V02:K0:IH3wcLvi/kl5m/PZmscvpw+BuTTZZduebQQpJmwFIv8 qZArHjBNl0W011gDXKsyVdedPqyR33kzsj6YbiIxHpfjEU6C32 HVW+Dhcr+lqUucT4WruSjiBWkKVpdc9gg8DeTOSmMZ+3D8bzvQ HtPpJd+F3UKKih2pc4j7xiPJvRet1nBrvTooj1/tsc2wV9FezF rDckbOQnxfnX2DhIxz7XTSahoxbIxWnLxl3lEwsOR48bEjBgI5 8+/w0ZjdIfw/Il62DdSp60n3RLioqM9qi6G8aCp68Zsd6VMEeA MBRgixs73kyiAYe3oq0q/FyXGDYWyu08edhItpGh3HLDFgz9mQ ksAijkbTsl5SD98rBBnVJGsMxl+mIPSHIHmQrwM2/ X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.847 tagged_above=-10 required=5 tests=BAYES_00=-1.9, DC_IMAGE_SPAM_HTML=0.81, DC_IMAGE_SPAM_TEXT=0.242, DC_PNG_UNO_LARGO=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201110/11 X-Sequence-Number: 45233 This is a multi-part message in MIME format. --------------010001010903040006030005 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit On 10/01/2011 07:39 PM, David Boreham wrote: > I've already tried bonnie++, sysbench and a simple WAL emulation > test program I wrote more than 10 years ago. The drive tests at > around 160Mbyte/s on bulk data and 4k tps for commit rate writing > small blocks. That sounds about the same performance as the 320 drive I tested earlier this year then. You might try duplicating some of the benchmarks I ran on that: http://archives.postgresql.org/message-id/4D9D1FC3.4020207@2ndQuadrant.com Make sure to reference the capacity of the drive though. The 320 units do scale their performance based on that, presumably there's some of that with the 710s as well. I just released a new benchmarking wrapper to measure seek performance of drives and graph the result, and that's giving me interesting results when comparing the 320 vs. traditional disk arrays. I've attached a teaser output from it on a few different drive setups I've tested recently. (The 320 test there was seeking against a smaller data set than the regular arrays, but its performance doesn't degrade much based on that anyway) The program is at https://github.com/gregs1104/seek-scaling but it's still quite rough to use. -- Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us --------------010001010903040006030005 Content-Type: image/png; name="array-vs-ssd.png" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="array-vs-ssd.png" iVBORw0KGgoAAAANSUhEUgAAAoAAAAHgCAMAAAACDyzWAAABKVBMVEX///8AAACgoKD/AAAA wAAAgP/AAP8A7u7AQADu7gAgIMD/wCAAgECggP+AQAD/gP8AwGAAwMAAYIDAYIAAgABA/4Aw YICAYABAQEBAgAAAAICAYBCAYGCAYIAAAMAAAP8AYADjsMBAwIBgoMBgwABgwKCAAACAAIBg IIBgYGAgICAgQEAgQIBggCBggGBggICAgEAggCCAgICgoKCg0ODAICAAgIDAYACAwODAYMDA gADAgGD/QAD/QECAwP//gGD/gIDAoADAwMDA/8D/AAD/AP//gKDAwKD/YGAA/wD/gAD/oACA 4OCg4OCg/yDAAADAAMCgICCgIP+AIACAICCAQCCAQICAYMCAYP+AgADAwAD/gED/oED/oGD/ oHD/wMD//wD//4D//8BUJrxzAAAUWUlEQVR4nO2diZajNhAAYbLJ/39ydmYw6EYSOrpF1Xux 1zYtYVzT3cJHtg0AAAAAAAAAAAAAAAAAAAAAAMBg33O22bO3BYiy775Czj2hTc6NEBCe8O2P 55B9R3ATzIMmfDQ6stzvla1ccJPP3dd9x/WGl1CCpdx1ZeY3z8pDNvvfVzhAET/q/FhmXAU2 +fxzR0BoyWXXeRUX8JQsIGBkuQIQxau9fgkObhLNgABF2EuL0CIksIlfs8mAMB96QJgLGRAA AAAAAAAAAAAAAAA+fN585z0kmAEfI4KpnAKSAGEW3kfJd4B8Hut3ftXhvKt2qLFxSnaTw5IO 9758qOYpKNlNDksy2vmizZRdWfxIc1hS0UcVt2q5kqegZDc5LMOG/BobVzsdNAUBB/J0zTfw XFfxVLX7JkjAJXBOLXi/k+Vs6l3Zj3mDpyaOjZk62RF9LBZRHHAHArbGkSz6WOT76uZjRbM6 X3CPDe3vbPCxZgG3O14XNnhITRjfPjd+B+aToLxtowJuZ5wxynWnu/CLCLglnDEe83fXuDPw Mw/BL9vXHa66sB5DLtIDmiachdG429jQOIn/+4am85grZ0Aye1p7sFNAd2TnXSszLnQVCDBm 9/blnzvsw1V0cLNAQF/AM1MEt/3NKM6ju/XDHdbm+757Y122nYMZHjoGWbfOe3MFtHbCn6Hw cNWFDR5SE5EMuFn/MG47SdJ8zKih9tCB0cyZgiLFdtZPtalw+46MGe5AwNa4Ano11NjOlsxW y1bAGzpYgoNe3Ah4Z97dniGgKHanKHnnQ+xuzC5mm/PYuYk5tP2YO623SfrDctcfirnX7iLE F9CeITnF3QGrC+sx5CI9IBSBgDAVQQLCG0FAmAoC9iV84kX+ISreRRYho6a7CC1HnVtBAUMv 1m4NZi5qr1ESC+XgtO6KPPIUgg81C7gDAatJnSdLBoUFtAdzziaat0IBzrS7OY15JjEybWQ/ WwTcIUhAbUQF3KyEZt8yzHBO5MUFtD9p4E4UMOwMCJxhDD4HM/G6gfbogfOAxhOrAAEfsac/ RuCIFExvV1gs7rqITxQuwV7QWZftaa+nEroKBBg77/0N/rnDPoKFRzyD9wj4yRNuArr7AMuV NawX1rwzKGD88wrbtlmPnf/OEPC8N1dAY5T7LvP2GNaF9RhSWw94VlL36OcKGIlJZMDEREkB UyXYmDZ1FZ0SAWcuQja/lF5p49woKmAgLlfAlCXetFE7MszLmHYRAbVhliH7XkNOq0R9bgXi gmXPrHOJiQKDOauIqB7unpm3guHOfFYlrjuKdWGDh1RH7cvxPhCwCwiYiyABtfWA0AIEhKkI ElAfbqE9+vE5OxMntQxOxHQO+MTVhQ0ech6hladx0904cOd2LRKtRa27cnRuGAHBaZ0FdmgH r8VwYhUc+YNpFnAHAiYJn4NIbR0W8PY8oJ05k6fZdnMaWy5/d/1tEs/PfSotAu4QJKDEHjD4 ihoJzb5lmJE4yRcU0Hbkssu3J/VJA3d3b/sB+7Se81RC+TNwHjBvpuge1IX1GFKigN94FS4o UtKuZJwlbnCicAn+hEd3N5itdksW44aXcd0dDD6VQIr+9w57fyJH/QErleDNe4Vjrrl3uq+a eee9gJv72gfyY1DAwO56z8ffs81qKO8ENEYJNqJFIGCaUILJzIDBmFiSjAhoVWNvy937pEEi H8aenrFnqavoXiFgTzyRzpxwPhoV0KuF+QKmFPCmNR4y1YyUYP/53ZiXeiprCSixB7Trz3Y1 QNdjVwbZjYKVWITsxpb3EwUGc5YIlh7W7PdLA3fnzVuRGaxdsipxFQhYTu2xHoiCXTwQJKAa 9Ly6CkBAmAoCwlQECaimB0wTOJ2yVbfo0yjeYRYho6bb3NXlzam468SLP8i1VA0ujcMTWQHh FbIVkDpJEl2+Ngu4o5uA/9xspZjwiYnU1mEBc88f5gec8zkB0f2L7nxcwMKAO/plwH8WVtB9 mTcrodm3DAETJwczBTTvDAsYmiEuh31az9nrM4H6YzpnGoWeB1xWwVBlDHqRtisV9zkxnKio twIeN90Owdx748YefSckEGBMu7vvhPx3h72DOQe8DGPI2/9lhEY+h918yn0+obB71dMUIjCm v1/7Jyeb03o7sZ3C5whojGLFVdFXwCK0LEJ+LNx308m/t77v+LnzvAjeGYzx4q5NMicyN3Bv fDsS+2OydyJ1FdgB/2lm/OW6CBJQDcFGbb+SiXnnbYOXsUl+wPnPawO3iQs+lYyrjIC6g1kX NnhIYcR6wO2sTVeftBtVLLEI2Y0t7ye6E9Coj2k93P00b7nzeQGbtSUCzqX2BeiDrL1JIUhA LT1gGD0vuSwQkLiZ00kSUAlKREJAgAwQEKYiSEAltQaagoDEzZxOkoBKUCISAgJkgIAwFUEC Kqk10BQEJG7mdJIEVIISkRAQIAMEhKkIElBJrYGmICBxM6eTJKASlIiEgAAZICBMRZCASmoN NAUBiZs53VMBja+HthpSOkpEeoeA4S/PPxoS3gUCwlSe27K7PyP28zsNX98peczF19AwLtpd PPhFj5PzB8CeZ8DFmx0lcbp6wO36QajXlGAlIr1DwOsHwN4jIDTlqYCh3x17uk/wIjgRDVNB QOJmTidJQCUoEQkBATJAQJiKIAGV1BpoCgISN3M6SQIqQYlICAiQAQLCVAQJqKTWQFMQkLiZ 00kSUAlKREJAgAwQEKYiSEAltQaagoDEzZxOkoBKUCISAgJkgIAwFUECKqk10BQEJG7mdJIE VIISkRAQIAMEhKkIElBJrYGmICBxM6eTJKASlIiEgAAZICBMRZCASmoNNAUBiZs5nSQBlaBE JAQEyAABYSqCBFRSa6ApCEjczOkkCagEJSIhIEAGCAhTESSgkloDTUFA4mZOJ0lAJSgRCQEB MkBAmIogAZXUGmgKAhI3czpJAipBiUgICJABAsJUBAmopNZAUxCQuJnTSRJQCUpEQkCADBAQ piJIQCW1BpqCgMTNnE6SgEpQIhICAmSAgDAVQQIqqTXQFAQkbuZ0kgRUghKREBAgAwSEqQgS UEmtgaYgIHEzp5MkoBKUiISAABkgIExFkIBKag00BQGJmzndYwH3/efim1ZDCkeJSC8RcD8E bDgkvIpntuxGBmw0JLyLRiXYzII/On59p+QxF19Dw7iouvjzF+8BO3HVcQ7wvAdcvNlREtd6 uj+/ROMECagEJSLNF/DGvIMeJfjhkKCcu6Rn8XARclRxFiGwFZp3wIloaECFeQcISNyTsDPp 1e6mIAGVoESk3gK65RYBYRD15TYEAkIuNWuMWwQJKLTWQB/zDhCQuHhYgXn0gKNQItJDAYtz HgJCE3qW2xAICL+MNu9AkIBKesD1mGPeAQK+OC6U9EbvpiABlSBQpOK4RLlFQOjJ1HIbAgFf wqQ1xi2CBFTSA2pDqnkHCLhsXJ159IDSUSDgk5yHgFCP8HIbAgGXQKF5B4IEVNIDCkOteQcI qDXuLukpOSyCBFTCdAEzy+1qAu7Z2y4u4ES0l9sQubbs+5b7QzII2By9a4xbsgX8+S22pkO6 KOkBh7KweQf5AmbX4MUFHBN3mbf4YckvwftGCf6m9yvk5jwEPDdkEdKV9cttCE7DzOed5h1k 2VL2O6qL94AtebN5B5kClii4uIBN4gZ841vJYcnt6woMXLwEP3uFysstAh4bZiu4uIC1UG6D FCQ23gmp49VrjFtKbOksoJJaUwDm3SPoNIwSAfPi5n/jW+Rh8clehOQ3gYuX4NsjHUl7CBgk s6rue/7/VmlxAVNQcovJdmov2fiF4F4dggRUUmt8cO8BgkqwEgH9dzQGztc/jh5QOp8jLfwd jbUEnD2kMKi57SADFoJ7bcn/MAI9IImvAwXfims9pItkAQ33lPRyq/WA7/04lpv3lIi0mIDv 7AGpuf1hERIG9wYh6DSMlFqDeyNBQJMc95T0cov1gJOHHIDULwkhoIQh+0LNncjbBcS9yQgS cHitQT4BvFXAevmU9HL0gHJ5lvmUiISAMqHsCuNNAiKfQAQJ2DX5+/JJ+HUseIWAqr+nSw8o Ych62pddJSIh4Hzo+RSwqoDIpwRBArZL/lnysQgRwXoC5qY+JT0ZPaCEIfPpX3iViISAE6Dv 08c6AmKfSgQJ+CT5V9jHIkQEKwhYl/uU9GT0gDfx+++l8ZXNwSV4dOVVItJLBPwV7/viMnCk gDR+2nlmy/G/cJ0kIPYtQJMSbP+G/s9vKHx9p+SeF3/tO/71VTdAZRgX7S7yf20jziHg3iAD FnQRLf6Pzkp6MnrAm/gJJXhu5VUiEgJ2gsZvLR4uQo4qPuo0DPYth6YT0RH7BtcaaIoiAWPJ T0mzoyROWw84ZshvpBRfJSIhYGOk+Adt0SIg/i2KIAFTSTzlH4sQzegQMJn/lDQ7SuLoAQOI qr9KRELAdojyD9qiQED8WxlBAoaT+P2bbyxCNCNdwH4/caCkJ6MHnDqkwPKrRCQEbIFA/6At ogXEv/URJKCXxDP9YxGiGcEC5uY/Jc2Okjh6wA9S668SkRDwIVL9g7ZIFRD/XoIgAc0kXuIf ixDNyBSwKP8paXaUxNEDzv7i+R1KRELAakTrB8X8+yH4qDwB8U81/3qktxck4E8Sryi/LELm UaqbjzABB/7WrpKeTFIPmNJtjR5QQ/lVItJzAcuy2woCyl79Ls7zYlqHIAHRbxyzdPMRI+Cf P4KancWQo5uPFAH/iOq2dcc90u2lJ6IVlV9pAsbSm5K/SxECsvrIRnI1rUKCgOgXYzndfAQI +PFPSQ/Yjxfo5jNdwKv8KhGwVVyubosfltkC6iu/dUe6PrshYM8h9fmXz9uKaR0I2BicK2Ou gJZ/SmpNELSrZaqAdv5TIqARV6Td7EWPzOkkCaiEr8psh4BBZgqoyj+KbB8mCqjBP7TrjSAB 5dQatBvHPAG9BDhbwEztlPRy9IA3yCnAhdlOiUgIeMN8ASmzEpgl4Ez/EE8QkwQM+dc9+dsp T97HsV7JKwQMpjwlPRk9YI8hBxXgLl2eEpEQMMEA/+jylLCigLiniBkCRvxrk/yz5WMRIoKl BCxKfUp6MnrA5kN2KsCj6q4SkRAwRg//6PrUsoCAyKeZ4QLG/atK4n/tk/CdEKhltICJ/Fds xFF4lTQ7SuJW7wGbFeBphVeJSAgYpI1/rDnWYayALfxDvqUQJGBGEg+mPhYhmhkqYDoBZvwU aFVc5XQvjVu5B3xSgOUUXiUiIaBPtYBy7IPWDBSwzj9WvGszTsBb/wJJPEs+FiGaESxgbupT 0uwoiVPZA+4/pIcsLMByC68SkV4m4P2QJQLKtQ9a0y4Dpocs8A/73kSzDGiU4G++vlOycfHH vhm9+E5+OdsZF18lGz8O46LdhZ24HpLuAXMS4Fdl8lPS7CiJi4T914DgwIIEVNL5jRapxUv/ nG5Pr0cJ9jfI8E+HfdkMfOl10yYD3i1CbgXUr9+7tGnHkBPRN/4dtVdGs5MNxjVhvoBn8hMv 4DPjdC9CusXNFlB07Q0mOSUiIeBF3D9p+lFWhzNVQBH6YdxUBggY82/uT5YinQzmCeilvyEC Xt4p6cnoAZ8OGfZvcPfXMN8pEQkBPwQFHKQfdVY8UwTsn/7wTgvdBfT9i+nXJvlnm/f0nRBo wngBo9nvqYCFSU9JT0YP+GxI178+1XdkvVUiEgL+4gjYXD96PeV0FtD2r236Q70VGCngjX75 SdxOe5M+jgVN6Cug6d9t+ssxIlRxlTQ7SuLW6gENAR9XXykVV4lICPjNJeAz/4S4B+0ZJGC9 f1ISH/Shq4BlCdBP4nnusQjRzBgBsxKg/5Za3nxKmh0lcUv1gB8BSwuw6KqrRCQE3E4Bi/wT LR80Z4CA+f4h3/uQI2C1fCxCNNNTwHz/ZnxJQ0lPtvph6S7grX/a6q4SkRDwV8Ab/5TJB82Z KiD2QWcBU/41+lQLixDVdBQw7Z+f/ZQIuHjcQj1gSkDFxVeJSAj4V8CYf4r1g8ZMEBD94GK4 gHH9lNQaaEo/AYP+pbKfEgEXj1unBwwIuETxVSISAnoCLqEfNKajgLZ/6AchRgnY77sdLEJU M0jAnr+XpqTZURK3TA9Y7J8WlIiEgIaAK/kHbRkhIP5BlG4ClvunpNZAU/oLmJ3/lAi4eNwy PeCH5eqvEpEQ8Jfl/IO2dBYQ/yBNXwGL/FNSa6ApXQUsy39KBFw8bqkecMkCrEQkBFzUP2gL AsJUOgpY6p+SWgNNQUDiZk7XUcBVC7ASkRBwVQGhKd0ExD/IQZCASmoNNKX7p2HyUSLg4nHr 9ICrokQkBATIAAFhKoIEVFJroCkISNzM6SQJqAQlIiEgQAYICFMRJKCSWgNNESTg4Dglu8lh yRrlL9N2ZfEjzWHJGGT//W/Orix+pDksGYMg4DJxSnbTGWTfjBq8A+TTRsB9azMSQAV2CQYY DALCXFrVcgAAAAAAAABt1K2Jf2OKY4+A0rjKsN/Quulq4p48vdr9rJiuLs56xRueSKk7K/jZ jcLYI6A0rjLss6NVu7mNe3qf2FGHpSrOesVbnkquO1rbUAGP0IqwvVLA/RMzRFwjRqqA9ive WMCadPrZnfLY3/0vizuFKK5RldPV72bVfhpTDjgsdU/PfMUrpYmMW/XRhE8nUJGS6ua8nnpR TFXc+PmqDmf1dPtRGIrizF1s+XmWymxaV4KPrUeV4P1zpMf0ZA8KVNXhfFIPy+M6luBxAu51 TdLYIz24u/8Eyu4B+wm41Z3bqD9vUBu31e5qRdzQ8xub8Yc55rBUxDmvXMPTMAAAAAAAAAAA AAAAALA2d28s8cYT9MH4wEx6szG7A+/j/JTH7UYAHTg/3bGfV5t/VfOZGoAMAp9zMz7uFrwT oB2ugJv94bfLPOyDHgQFPK+s1IeC0J6IgF7tJQlCFwICBlYfLEIAAAAAAABm8z9BnlOVgeUV TwAAAABJRU5ErkJggg== --------------010001010903040006030005--