DB on mSATA SSD - Mailing list pgsql-general

From Job
Subject DB on mSATA SSD
Date
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A04F71C6F9B0F@W2008DC01.ColliniConsulting.lan
Whole thread Raw
Responses Re: DB on mSATA SSD  (Vick Khera <vivek@khera.org>)
Re: DB on mSATA SSD  (John McKown <john.archie.mckown@gmail.com>)
Re: DB on mSATA SSD  (Chris Mair <chris@1006.org>)
Re: DB on mSATA SSD  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-general
Dear Postgresql mailing list,

we use Postgresql 8.4.x on our Linux firewall distribution.
Actually, we are moving from standard SATA disk to mSATA SSD solid drive, and we noticed that the DB, using lots of
indexes,is writing a lot. 

In some monthes, two test machine got SSD broken, and we are studying how to reduce write  impact for DB.

Are there some suggestions with SSD drives?
Putting the DB into RAM and backing up periodically to disk is a valid solutions?

Or, is storing indexes on a ram drive possible?

Thank you in advance for your appreciated interest!

Best regards,
Francesco

pgsql-general by date:

Previous
From: PT
Date:
Subject: Re: What constitutes "reproducible" numbers from pgbench?
Next
From: Vick Khera
Date:
Subject: Re: DB on mSATA SSD