Re: DB on mSATA SSD

Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> · Thu, 23 Apr 2015 16:21:53 +0300



    On 23/04/2015 15:28, Vick Khera wrote:

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