| From: | Vick Khera <vivek(at)khera(dot)org> |
|---|---|
| To: | Job <Job(at)colliniconsulting(dot)it> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: DB on mSATA SSD |
| Date: | 2015-04-23 12:28:32 |
| Message-ID: | CALd+dcez2OZYTr-YbS-MUSS4R-=eVvJQJFGbofOYhi9_0pg+1w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Apr 23, 2015 at 7:07 AM, Job <Job(at)colliniconsulting(dot)it> wrote:
> Are there some suggestions with SSD drives?
> Putting the DB into RAM and backing up periodically to disk is a valid
> solutions?
>
I have some very busy databases on SSD-only systems. I think you're using
SSDs that are not rated for server use.
Your strategy of using in-ram disk and backing up to the SSD is sensible,
depending on what guarantees you need for the data to survive an unclean
system shutdown. You will want to use a file system that allows you to
snapshot and backup or logical DB backups. Postgres 9.4 has some features
that will make taking the backup from the file system much easier and
cleaner, too.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John McKown | 2015-04-23 12:33:10 | Re: DB on mSATA SSD |
| Previous Message | Job | 2015-04-23 11:07:34 | DB on mSATA SSD |