Re: DB on mSATA SSD

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: DB on mSATA SSD
Дата
Msg-id CALd+dcez2OZYTr-YbS-MUSS4R-=eVvJQJFGbofOYhi9_0pg+1w@mail.gmail.com
обсуждение исходный текст
Ответ на DB on mSATA SSD  (Job <Job@colliniconsulting.it>)
Ответы Re: DB on mSATA SSD  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Список pgsql-general

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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Job
Дата:
Сообщение: DB on mSATA SSD
Следующее
От: John McKown
Дата:
Сообщение: Re: DB on mSATA SSD