From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL? |
Date: | 2015-03-13 11:40:31 |
Message-ID: | 5502CCAF.4030606@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 03/13/2015 04:27 AM, Achilleas Mantzios wrote:
>
> Hello,
>
> we maintain a DB of nearly 500GB of data (and always getting larger),
> and we are currently thinking of moving to SSD.
> I have read Greg Smith's book on PostgreSQL 9.0 High Performance and his
> considerations on SSD and the way that write back works.
>
> This particular model (Samsung SSD 850 PRO 1T) does not employ any
> special circuitry, battery or capacitor
> to enforce that the data are really flushed to the medium.
>
> What is your take on this? Is it dangerous to have PgSQL on this disk
> especially in cases of power outages? (we have full UPS support, however
> nothing can be overlooked, anything can happen)
If it does not have power loss protection, don't use it.
JD
--
The most kicking donkey PostgreSQL Infrastructure company in existence.
The oldest, the most experienced, the consulting company to the stars.
Command Prompt, Inc. http://www.commandprompt.com/ +1 -503-667-4564 -
24x7 - 365 - Proactive and Managed Professional Services!
From | Date | Subject | |
---|---|---|---|
Next Message | Matheus de Oliveira | 2015-03-13 11:55:27 | Re: Errorlog empty |
Previous Message | Achilleas Mantzios | 2015-03-13 11:27:11 | Samsung SSD 850 PRO 1T : any good for PostgreSQL? |