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!