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! -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
