| From: | Job <Job(at)colliniconsulting(dot)it> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | DB on mSATA SSD |
| Date: | 2015-04-23 11:07:34 |
| Message-ID: | 88EF58F000EC4B4684700C2AA3A73D7A04F71C6F9B0F@W2008DC01.ColliniConsulting.lan |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vick Khera | 2015-04-23 12:28:32 | Re: DB on mSATA SSD |
| Previous Message | PT | 2015-04-23 10:51:50 | Re: What constitutes "reproducible" numbers from pgbench? |