Postgres Pro
Downloads
Home   >   mailing lists

Re: DB on mSATA SSD - Mailing list pgsql-general

From Achilleas Mantzios
Subject Re: DB on mSATA SSD
Date
Msg-id 5538F1F1.90909@matrix.gatewaynet.com
Whole thread Raw
In response to Re: DB on mSATA SSD  (Vick Khera <vivek@khera.org>)
List pgsql-general
Tree view
On 23/04/2015 15:28, Vick Khera wrote:

On Thu, Apr 23, 2015 at 7:07 AM, Job <Job@colliniconsulting.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.


FS Snapshots are an option but one should make sure that all file systems are snapshot atomically, which is not very common unless you use ZFS or similarly high-end FS.
Regarding file filesys based backups, apart from pg_basebackup which is a nice utility but built on top of the existing "Continuous Archiving" philosophy, the very feature was already implemented since 8.*
-- 
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt

pgsql-general by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: DB on mSATA SSD
Next
From: Tomas Vondra
Date:
Subject: Re: DB on mSATA SSD