SSD endurance calculations

From: Christiaan Willemsen <cwillemsen(at)technocon(dot)com>
To: pgsql-performance(at)postgresql(dot)org <pgsql-performance(at)postgresql(dot)org>
Subject: SSD endurance calculations
Date: 2011-11-21 21:03:46
Message-ID: zarafa.4ecabcb2.0527.762392872b021f28@meel.technocon.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hey there,

 
We are looking at beefing up our servers with SSD's. Some of you did some interesting tests with the Intel 320. So the idea came to make a RAID10 with four 600GB models.

 
I did however do some calculations with the current database server (220GB database, expected to grow to 1TB by the end of next year). I specifically looked at /proc/diskstat at the read/write figures. From there I could see a read/write ratio of 3:1, and I also saw a wopping 170GB of writes per day (for a database that currently grows 1GB per dag). That seems like an insanely high figure to me! How come? We do mostly inserts, hardly any updates, virtually no deletes.

 
Secondly, I also looked at the reliability figures of the Intel 320. They show 5 years of 20GB per day, meaning that it will hold up for about 200 days in our system. RAID 10 wil make 400 days of that, but this seems hardly a lot.. Am I missing something here?

 
Kind regards,

 
Christiaan

 
 
 

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Edgardo Portal 2011-11-22 16:59:17 Re: SSD endurance calculations
Previous Message Rauan Maemirov 2011-11-21 05:53:47 Re: Problems with FTS