Message-ID: <5502CCAF.4030606@commandprompt.com>
Date: Fri, 13 Mar 2015 04:40:31 -0700
From: "Joshua D. Drake" <jd@commandprompt.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:31.0) Gecko/20100101 Thunderbird/31.5.0
MIME-Version: 1.0
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>,
 pgsql-admin@postgresql.org
Subject: Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
References: <5502C98F.2090806@matrix.gatewaynet.com>
In-Reply-To: <5502C98F.2090806@matrix.gatewaynet.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin