From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@postgresql.org
Subject: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
Date: Fri, 13 Mar 2015 13:27:11 +0200
Message-ID: <5502C98F.2090806@matrix.gatewaynet.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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)
Thank you
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: achill@matrix.gatewaynet.com
Subject: Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
In-Reply-To: <5502C98F.2090806@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox