Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZCWMd-0005n4-9d for pgsql-performance@arkaria.postgresql.org; Tue, 07 Jul 2015 17:08:59 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZCWMc-0003LT-Im for pgsql-performance@arkaria.postgresql.org; Tue, 07 Jul 2015 17:08:58 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZCWJl-0000GU-C5 for pgsql-performance@postgresql.org; Tue, 07 Jul 2015 17:06:01 +0000 Received: from wsip-70-169-168-7.pn.at.cox.net ([70.169.168.7] helo=fs.denninger.net) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZCWJh-0007TN-Ki for pgsql-performance@postgresql.org; Tue, 07 Jul 2015 17:06:00 +0000 Received: from [192.168.1.40] (localhost [127.0.0.1]) by fs.denninger.net (8.14.9/8.14.8) with ESMTP id t67H5ue5068070 for ; Tue, 7 Jul 2015 12:05:56 -0500 (CDT) (envelope-from karl@denninger.net) Received: from [192.168.1.40] [192.168.1.40] (Via SSLv3 AES128-SHA) ; by Spamblock-sys (LOCAL/AUTH) Tue Jul 7 12:05:56 2015 Message-ID: <559C06ED.10706@denninger.net> Date: Tue, 07 Jul 2015 12:05:49 -0500 From: Karl Denninger User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Thunderbird/31.7.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: New server: SSD/RAID recommendations? References: <31701C89A44B714FB8D242F806E7286C5AED32FA@NTXBOIMBX01.micron.com> <559AB332.50304@pinpointresearch.com> <52A08B87-2A8A-43F2-92CE-2514F5AD141B@skogoglandskap.no> <1253229687.3798367.1436264898828.JavaMail.zimbra@desy.de> <985C5CEF-2E55-46AD-A29F-90D48D057A3F@skogoglandskap.no> <1052663055.3807152.1436266613895.JavaMail.zimbra@desy.de> <559BB7D8.6090701@denninger.net> <559BC865.9080804@denninger.net> <2E6806BA-DBC0-46B8-9E93-9EBA788AC273@skogoglandskap.no> In-Reply-To: <2E6806BA-DBC0-46B8-9E93-9EBA788AC273@skogoglandskap.no> Content-Type: multipart/signed; protocol="application/pkcs7-signature"; micalg=sha1; boundary="------------ms010608050402010606050903" X-Pg-Spam-Score: -0.9 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org This is a cryptographically signed message in MIME format. --------------ms010608050402010606050903 Content-Type: multipart/alternative; boundary="------------080002060803010707010305" This is a multi-part message in MIME format. --------------080002060803010707010305 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable After a plug-pull during the create, reboot and here is the verify: root@Dbms2:/var/tmp # ./diskchecker.pl -s newfs verify /test/biteme verifying: 0.00% verifying: 3.81% verifying: 10.91% verifying: 18.71% verifying: 26.46% verifying: 33.95% verifying: 41.20% verifying: 49.48% verifying: 57.23% verifying: 64.89% verifying: 72.54% verifying: 80.04% verifying: 87.96% verifying: 95.15% verifying: 100.00% Total errors: 0 da6 at mps0 bus 0 scbus0 target 17 lun 0 da6: Fixed Direct Access SPC-4 SCSI device da6: Serial Number BTJR446401KW240AGN=20 da6: 600.000MB/s transfers da6: Command Queueing enabled da6: 228936MB (468862128 512 byte sectors: 255H 63S/T 29185C) # smartctl -a /dev/da6 =3D=3D=3D START OF INFORMATION SECTION =3D=3D=3D Model Family: Intel 730 and DC S3500/S3700 Series SSDs Device Model: INTEL SSDSC2BP240G4 Serial Number: BTJR446401KW240AGN LU WWN Device Id: 5 5cd2e4 04b71afc7 Firmware Version: L2010420 User Capacity: 240,057,409,536 bytes [240 GB] Sector Size: 512 bytes logical/physical Rotation Rate: Solid State Device Form Factor: 2.5 inches Device is: In smartctl database [for details use: -P show] ATA Version is: ATA8-ACS T13/1699-D revision 4 SATA Version is: SATA 2.6, 6.0 Gb/s (current: 6.0 Gb/s) Local Time is: Tue Jul 7 17:01:36 2015 CDT SMART support is: Available - device has SMART capability. SMART support is: Enabled Note -- same firmware between all three series of Intel devices...... :-)= Yes, I like these SSDs -- they don't lie and they don't lose data on a power-pull. On 7/7/2015 08:08, Graeme B. Bell wrote: > Thanks, this is very useful to know about the 730. When you say 'tested= it with plug-pulls', you were using diskchecker.pl, right? > > Graeme. > > On 07 Jul 2015, at 14:39, Karl Denninger wrote: > >> Incidentally while there are people who have questioned the 730 series= power loss protection I've tested it with plug-pulls and in addition it = watchdogs its internal power loss capacitors -- from the smartctl -a disp= lay of one of them on an in-service machine here: >> >> 175 Power_Loss_Cap_Test 0x0033 100 100 010 Pre-fail Alwa= ys - 643 (4 6868) > > --=20 Karl Denninger karl@denninger.net /The Market Ticker/ /[S/MIME encrypted email preferred]/ --------------080002060803010707010305 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable After a plug-pull during the create, reboot and here is the verify:
root@Dbms2:/var/tmp # ./diskchecker.pl -s newfs verify /test/biteme =A0verifying: 0.00%
=A0verifying: 3.81%
=A0verifying: 10.91%
=A0verifying: 18.71%
=A0verifying: 26.46%
=A0verifying: 33.95%
=A0verifying: 41.20%
=A0verifying: 49.48%
=A0verifying: 57.23%
=A0verifying: 64.89%
=A0verifying: 72.54%
=A0verifying: 80.04%
=A0verifying: 87.96%
=A0verifying: 95.15%
=A0verifying: 100.00%
Total errors: 0

da6 at mps0 bus 0 scbus0 target 17 lun 0
da6: <ATA INTEL SSDSC2BP24 0420> Fixed Direct Access SPC-4 SCSI device
da6: Serial Number BTJR446401KW240AGN=A0
da6: 600.000MB/s transfers
da6: Command Queueing enabled
da6: 228936MB (468862128 512 byte sectors: 255H 63S/T 29185C)

# smartctl -a /dev/da6

=3D=3D=3D START OF INFORMATION SECTION =3D=3D=3D
Model Family:=A0=A0=A0=A0 Intel 730 and DC S3500/S3700 Series SSDs Device Model:=A0=A0=A0=A0 INTEL SSDSC2BP240G4
Serial Number:=A0=A0=A0 BTJR446401KW240AGN
LU WWN Device Id: 5 5cd2e4 04b71afc7
Firmware Version: L2010420
User Capacity:=A0=A0=A0 240,057,409,536 bytes [240 GB]
Sector Size:=A0=A0=A0=A0=A0 512 bytes logical/physical
Rotation Rate:=A0=A0=A0 Solid State Device
Form Factor:=A0=A0=A0=A0=A0 2.5 inches
Device is:=A0=A0=A0=A0=A0=A0=A0 In smartctl database [for details use= : -P show]
ATA Version is:=A0=A0 ATA8-ACS T13/1699-D revision 4
SATA Version is:=A0 SATA 2.6, 6.0 Gb/s (current: 6.0 Gb/s)
Local Time is:=A0=A0=A0 Tue Jul=A0 7 17:01:36 2015 CDT
SMART support is: Available - device has SMART capability.
SMART support is: Enabled

Note -- same firmware between all three series of Intel devices...... :-)

Yes, I like these SSDs -- they don't lie and they don't lose data on a power-pull.


On 7/7/2015 08:08, Graeme B. Bell wrote:
Thanks, this is very useful to know about the 730. When you say 'tested i=
t with plug-pulls', you were using diskchecker.pl, right?

Graeme.

On 07 Jul 2015, at 14:39, Karl Denninger <karl@denninger.net> wrot=
e:


Incidentally while there are people who have questioned the 730 series po=
wer loss protection I've tested it with plug-pulls and in addition it wat=
chdogs its internal power loss capacitors -- from the smartctl -a display=
 of one of them on an in-service machine here:

175 Power_Loss_Cap_Test     0x0033   100   100   010    Pre-fail  Always =
      -       643 (4 6868)

--
Karl Denninger
karl@denninger.net
The Market Ticker
[S/MIME encrypted email preferred]
--------------080002060803010707010305-- --------------ms010608050402010606050903 Content-Type: application/pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGXzCC BlswggRDoAMCAQICASkwDQYJKoZIhvcNAQELBQAwgZAxCzAJBgNVBAYTAlVTMRAwDgYDVQQI EwdGbG9yaWRhMRIwEAYDVQQHEwlOaWNldmlsbGUxGTAXBgNVBAoTEEN1ZGEgU3lzdGVtcyBM TEMxHDAaBgNVBAMTE0N1ZGEgU3lzdGVtcyBMTEMgQ0ExIjAgBgkqhkiG9w0BCQEWE0N1ZGEg U3lzdGVtcyBMTEMgQ0EwHhcNMTUwNDIxMDIyMTU5WhcNMjAwNDE5MDIyMTU5WjBaMQswCQYD VQQGEwJVUzEQMA4GA1UECBMHRmxvcmlkYTEZMBcGA1UEChMQQ3VkYSBTeXN0ZW1zIExMQzEe MBwGA1UEAxMVS2FybCBEZW5uaW5nZXIgKE9DU1ApMIICIjANBgkqhkiG9w0BAQEFAAOCAg8A MIICCgKCAgEAuYRY+EB2mGtZ3grlVO8TmnEvduVFA/IYXcCmNSOC1q+pTVjylsjcHKBcOPb9 TP1KLxdWP+Q1soSORGHlKw2/HcVzShDW5WPIKrvML+Ry0XvIvNBu9adTiCsA9nci4Cnf98XE hVpenER0qbJkBUOGT1rP4iAcfjet0lEgzPEnm+pAxv6fYSNp1WqIY9u0b1pkQiaWrt8hgNOc rJOiLbc8CeQ/DBP6rUiQjYNO9/aPNauEtHkNNfR9RgLSfGUdZuOCmJqnIla1HsrZhA5p69Bv /e832BKiNPaH5wF6btAiPpTr2sRhwQO8/IIxcRX1Vxd1yZbjYtJGw+9lwEcWRYAmoxkzKLPi S6Zo/6z5wgNpeK1H+zOioMoZIczgI8BlX1iHxqy/FAvm4PHPnC8s+BLnJLwr+jvMNHm82QwL J9hC5Ho8AnFU6TkCuq+P2V8/clJVqnBuvTUKhYMGSm4mUp+lAgR4L+lwIEqSeWVsxirIcE7Z OKkvI7k5x3WeE3+c6w74L6PfWVAd84xFlo9DKRdU9YbkFuFZPu21fi/LmE5brImB5P+jdqnK eWnVwRq+RBFLy4kehCzMXooitAwgP8l/JJa9VDiSyd/PAHaVGiat2vCdDh4b8cFL7SV6jPA4 k0MgGUA/6Et7wDmhZmCigggr9K6VQCx8jpKB3x1NlNNiaWECAwEAAaOB9DCB8TA3BggrBgEF BQcBAQQrMCkwJwYIKwYBBQUHMAGGG2h0dHA6Ly9jdWRhc3lzdGVtcy5uZXQ6ODg4ODAJBgNV HRMEAjAAMBEGCWCGSAGG+EIBAQQEAwIFoDALBgNVHQ8EBAMCBeAwLAYJYIZIAYb4QgENBB8W HU9wZW5TU0wgR2VuZXJhdGVkIENlcnRpZmljYXRlMB0GA1UdDgQWBBTFHJQt6cloXBdG1Pv1 o2YgH+7lWTAfBgNVHSMEGDAWgBQkcZudhX383d29sMqSlAOh+tNtNTAdBgNVHREEFjAUgRJr YXJsQGRlbm5pbmdlci5uZXQwDQYJKoZIhvcNAQELBQADggIBAE9/dxi2YqjCYYhiybp4GKcm 7tBVa/GLW+qcHPcoT4dqmqghlLz8+iUH+HCJjRQATVGyMEnvISOKFVHC6aZIG+Sg7J8bfS4+ fjKDi9smRH2VPPx3bV8+yFYRNroMGHaPHZB/Xctmmvc+PZ9O2W7rExgrODtxIOB3Zs6wkYf+ ty+9r1KmTHlV+rRHI6timH1uiyFE3cPi1taAEBxf0851cJV8k40PGF8G48ewnq8SY9sCf5cv liXbpdgU+I4ND5BuTjg63WS32zuhLd1VSuH3ZC/QbcncMX5W3oLXmcQP5/5uTiBJy74kdPtG MSZ9rXwZPwNxP/8PXMSR7ViaFvjUkf4bJlyENFa2PGxLk4EUzOuO7t3brjMlQW1fuInfG+ko 3tVxko20Hp0tKGPe/9cOxBVBZeZH/VgpZn3cLculGzZjmdh2fqAQ6kv9Z9AVOG1+dq0c1zt8 2zm+Oi1pikGXkfz5UJq60psY6zbX25BuEZkthO/qiS4pxjxb7gQkS0rTEHTy+qv0l3QVL0wa NAT74Zaj7l5DEW3qdQQ0dtVieyvptg9CxkfQJE3JyBMb0zBj9Qhc5/hbTfhSlHzZMEbUuIyx h9vxqFAmGzfB1/WfOKkiNHChkpPW8ZeH9yPeDBKvrgZ96dREHFoVkDk7Vpw5lSM+tFOfdyLg xxhb/RZVUDeUMYIE4zCCBN8CAQEwgZYwgZAxCzAJBgNVBAYTAlVTMRAwDgYDVQQIEwdGbG9y aWRhMRIwEAYDVQQHEwlOaWNldmlsbGUxGTAXBgNVBAoTEEN1ZGEgU3lzdGVtcyBMTEMxHDAa BgNVBAMTE0N1ZGEgU3lzdGVtcyBMTEMgQ0ExIjAgBgkqhkiG9w0BCQEWE0N1ZGEgU3lzdGVt cyBMTEMgQ0ECASkwCQYFKw4DAhoFAKCCAiEwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAc BgkqhkiG9w0BCQUxDxcNMTUwNzA3MTcwNTQ5WjAjBgkqhkiG9w0BCQQxFgQUKOvLyI8nsA3b qPwgClf7ztvPUMkwbAYJKoZIhvcNAQkPMV8wXTALBglghkgBZQMEASowCwYJYIZIAWUDBAEC MAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDANBggqhkiG9w0DAgIBQDAHBgUrDgMCBzAN BggqhkiG9w0DAgIBKDCBpwYJKwYBBAGCNxAEMYGZMIGWMIGQMQswCQYDVQQGEwJVUzEQMA4G A1UECBMHRmxvcmlkYTESMBAGA1UEBxMJTmljZXZpbGxlMRkwFwYDVQQKExBDdWRhIFN5c3Rl bXMgTExDMRwwGgYDVQQDExNDdWRhIFN5c3RlbXMgTExDIENBMSIwIAYJKoZIhvcNAQkBFhND dWRhIFN5c3RlbXMgTExDIENBAgEpMIGpBgsqhkiG9w0BCRACCzGBmaCBljCBkDELMAkGA1UE BhMCVVMxEDAOBgNVBAgTB0Zsb3JpZGExEjAQBgNVBAcTCU5pY2V2aWxsZTEZMBcGA1UEChMQ Q3VkYSBTeXN0ZW1zIExMQzEcMBoGA1UEAxMTQ3VkYSBTeXN0ZW1zIExMQyBDQTEiMCAGCSqG SIb3DQEJARYTQ3VkYSBTeXN0ZW1zIExMQyBDQQIBKTANBgkqhkiG9w0BAQEFAASCAgBYA4Dc uP0aC2z0m+S9RwqYpZ8dMndFUrqcoL3DZ41p4hvZLxhcmFujSDLswG+mH5+qkS71/+OrEImK IYCqZ0tlHqpI7tce+IIT6V/AsT6k2bGcSqkXoik0rt1xba9hfRtaK/iQhS0W5yE0LTOyzR32 lUe0CvscOGEvACmo4kZqOyNGoophajgYGnjgVB5I5XWRa6WpJRGQjie+t2CSmZDvM+Wv4PxM 9VQh0zMyFyHuRp+Yfwq8vKAs0HF8F7pcVFMkF5ykyqGf6NtVCmVOXRFMouwCcdArVYesGL5O +AGFzNqDi9jhjikWEz9/h2GQQGXU+/wQhQHcLclg0yBFEcWtFITG3m5Q1w+RHydH07PGzkL3 hf3s1jkuAe/0efUk1TjfkKgx9svZJhmGgmy2IqIJMBuZqvufs+/jcCdXr15yVi6Qa7HlwGS2 ITnVWv82cRl/GKCgoGbW8u3c7uCVMNGPqNfVH65X9vke09JK4yTfDhy/3Yc8+zkJVXOYZzfh u3uxX3qnxWDUyc/Qo1sUMOx4NwcyzGOrrP9O+fJOzSTclBiKqB2CDa6kc13H+IhGYv6S0kil Kok96s3xrrVFrKqV82uUKLUlQgqUYeZY/DkA++B9ykp8/EdRiy4ns71aT46QsHSCZOJ7XaSQ 0U+Dm01eRHsj8hPFXwYnVxLSDIpNGQAAAAAAAA== --------------ms010608050402010606050903--