From: Florian Weimer <fweimer@bfk.de>
To: Yeb Havinga <yebhavinga@gmail.com>
Cc: Andy <angelflow@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: BBU still needed with SSD?
Date: Tue, 19 Jul 2011 11:37:27 +0000
Message-ID: <82livubix4.fsf@mid.bfk.de> (raw)
In-Reply-To: <4E2569B0.2050307@gmail.com>
References: <1310953399.25726.YahooMailClassic@web111304.mail.gq1.yahoo.com>
<4E23E72B.2070508@gmail.com>
<82vcuyd7p5.fsf@mid.bfk.de>
<4E255DF9.20005@gmail.com>
<82y5zubl90.fsf@mid.bfk.de>
<4E2569B0.2050307@gmail.com>
* Yeb Havinga:
> On 2011-07-19 12:47, Florian Weimer wrote:
>>
>>> It would be interesting to see if the drives also show total xyz
>>> written, and if that differs a lot too.
>> Do you know how to check that with smartctl?
> smartctl -a /dev/<your disk> should show all values. If it shows
> something that looks like garbage, it means that the database of
> smartmontools doesn't have the correct information yet for these new
> drives. I know that for the recently new OCZ vertex 2 and 3 SSDs you
> need at least 5.40 or 5.41 and that's pretty new stuff. (I just
> happened to install Fedora 15 today and that has smartmontools 5.41,
> whereas e.g. Scientific Linux 6 has 5.39).
Is this "Total_LBAs_Written"? The values appear to be far too low:
241 Total_LBAs_Written 0x0032 100 100 000 Old_age Always - 188276
242 Total_LBAs_Read 0x0032 100 100 000 Old_age Always - 116800
241 Total_LBAs_Written 0x0032 100 100 000 Old_age Always - 189677
242 Total_LBAs_Read 0x0032 100 100 000 Old_age Always - 92509
The second set of numbers are from the drive which wears more quickly.
The read asymmetry is not unusual for RAID-1 configurations (depending
on the implementation; few do "read both and compare", as originally
envisioned, but prefer the primary block device instead). Reduced read
traffic could translate to increased fragmentation and wear if the drive
defragments on read. I don't know if the Intel 320s do this.
--
Florian Weimer <fweimer@bfk.de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99
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: fweimer@bfk.de, yebhavinga@gmail.com, angelflow@yahoo.com
Subject: Re: BBU still needed with SSD?
In-Reply-To: <82livubix4.fsf@mid.bfk.de>
* 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