pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedSSD, Postgres and safe write cache
3+ messages / 3 participants
[nested] [flat]
* SSD, Postgres and safe write cache
@ 2012-06-20 14:51 Michal Szymanski <mich20061@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Michal Szymanski @ 2012-06-20 14:51 UTC (permalink / raw)
To: pgsql-performance
Hi,
We started to think about using SSD drive for our telco system DB. Because we have many "almost" read-only data I think SSD is good candidate for our task. We would like to speed up process of read operation.
I've read post (http://blog.2ndquadrant.com/intel_ssd_now_off_the_sherr_sh/) about SSD which have write safe functionality and two drive are recommended Intel 320 and Vertex2 Pro. Both drive are rather inexpensive but both using old SATA II.
I tried to find newer faster version of Vertex because production Vertex 2 Pro is stopped but there is no information about new drives that has similar functionality and are cheap. Do you recommend cheap SSD drives that are suitable for DB needs?
Regards
Michal Szymanski
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: SSD, Postgres and safe write cache
@ 2012-06-25 16:05 Yeb Havinga <yebhavinga@gmail.com>
parent: Michal Szymanski <mich20061@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Yeb Havinga @ 2012-06-25 16:05 UTC (permalink / raw)
To: Michal Szymanski <mich20061@gmail.com>; +Cc: pgsql-performance
On 2012-06-20 16:51, Michal Szymanski wrote:
> Hi,
> We started to think about using SSD drive for our telco system DB. Because we have many "almost" read-only data I think SSD is good candidate for our task. We would like to speed up process of read operation.
> I've read post (http://blog.2ndquadrant.com/intel_ssd_now_off_the_sherr_sh/) about SSD which have write safe functionality and two drive are recommended Intel 320 and Vertex2 Pro. Both drive are rather inexpensive but both using old SATA II.
> I tried to find newer faster version of Vertex because production Vertex 2 Pro is stopped but there is no information about new drives that has similar functionality and are cheap. Do you recommend cheap SSD drives that are suitable for DB needs?
We were able to get OCZ Deneva 2's
(http://www.oczenterprise.com/downloads/solutions/ocz-deneva2-r-mlc-2.5in_Product_Brief.pdf)
from our supplier, which were suggested by OCZ as replacement for the
vertex 2 pro's. They're marketed as safe under power failure and our
tests with the diskchecker tool confirmed that.
regards,
Yeb Havinga
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: SSD, Postgres and safe write cache
@ 2012-07-01 04:37 Greg Smith <greg@2ndQuadrant.com>
parent: Michal Szymanski <mich20061@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Greg Smith @ 2012-07-01 04:37 UTC (permalink / raw)
To: pgsql-performance
On 06/20/2012 10:51 AM, Michal Szymanski wrote:
> We started to think about using SSD drive for our telco system DB.
> Because we have many "almost" read-only data I think SSD is good
candidate
> for our task. We would like to speed up process of read operation.
Many read-only operations can be made as fast as possible just by
getting more RAM. SSD is only significantly faster than regular disk on
reads if the working set of data is bigger than you can fit in memory,
but you can fit it all on SSD. That's not as many workloads as you
might guess.
> I've read post (http://blog.2ndquadrant.com/intel_ssd_now_off_the_sherr_sh/) about
> SSD which have write safe functionality and two drive are recommended
> Intel 320 and Vertex2 Pro. Both drive are rather inexpensive but both
using old SATA II.
Intel's 710 model is their more expensive one, but that's mainly due to
longer expected lifetime than speed:
http://blog.2ndquadrant.com/intel_ssds_lifetime_and_the_32/
I don't see a lot of need for a faster interface than SATA II on
database SSD yet. If you need the data really fast, it has to be in
RAM. And if it's so large that you can't fit it in RAM, you're likely
looking at random I/O against the SSD--where most are hard pressed to
saturate even a SATA II bus. Indexes for example can really benefit
from SSD instead of regular drives, but that's almost always random
access when you're in that situation.
There's not a lot of systems that are inside the narrow case where SATA
II SSD isn't fast enough, but similar performance per dollar SATA III
SSD is. Some of the PCI-E flash-based cards, like FusionIO's, can do a
lot better than SATA II. But they tend to use more flash in parallel
too, it's hard to get that much throughput out of most flash devices;
it's not just that they transfer to the host faster.
I'd build a prototype with whatever drives you have access to and try to
measure what you need here. I hate to see people jump right toward
leading edge SSD only to discover their real working set fits in memory
just fine, so it doesn't even matter. Or that the bottleneck is
somewhere else entirely.
--
Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-07-01 04:37 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-06-20 14:51 SSD, Postgres and safe write cache Michal Szymanski <mich20061@gmail.com>
2012-06-25 16:05 ` Yeb Havinga <yebhavinga@gmail.com>
2012-07-01 04:37 ` Greg Smith <greg@2ndQuadrant.com>
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