From: Karl Denninger <karl@denninger.net>
To: pgsql-performance@postgresql.org
Subject: Re: New server: SSD/RAID recommendations?
Date: Tue, 07 Jul 2015 12:05:49 -0500
Message-ID: <559C06ED.10706@denninger.net> (raw)
In-Reply-To: <2E6806BA-DBC0-46B8-9E93-9EBA788AC273@skogoglandskap.no>
References: <CAFwQ8rfwyBMD7AiL659qtG+UhsOUZthLSBYF7ODTn6TKxJoTPg@mail.gmail.com>
<VisenaEmail.44.70ed435cef1739b1.14e4c07dd3d@tc7-visena>
<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>
<B9C4FEE4-1527-4CB0-B941-CF6F2CF38D4E@skogoglandskap.no>
<559BC865.9080804@denninger.net>
<2E6806BA-DBC0-46B8-9E93-9EBA788AC273@skogoglandskap.no>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
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: <ATA INTEL SSDSC2BP24 0420> Fixed Direct Access SPC-4 SCSI device
da6: Serial Number BTJR446401KW240AGN
da6: 600.000MB/s transfers
da6: Command Queueing enabled
da6: 228936MB (468862128 512 byte sectors: 255H 63S/T 29185C)
# smartctl -a /dev/da6
=== START OF INFORMATION SECTION ===
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 <karl@denninger.net> 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 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 <mailto:karl@denninger.net>
/The Market Ticker/
/[S/MIME encrypted email preferred]/
Attachments:
smime.p7s (application/pkcs7-signature, 2.9K) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: karl@denninger.net
Subject: Re: New server: SSD/RAID recommendations?
In-Reply-To: <559C06ED.10706@denninger.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox