pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSamsung SSD 850 PRO 1T : any good for PostgreSQL?
12+ messages / 6 participants
[nested] [flat]
* Samsung SSD 850 PRO 1T : any good for PostgreSQL?
@ 2015-03-13 11:27 Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 2 replies; 12+ messages in thread
From: Achilleas Mantzios @ 2015-03-13 11:27 UTC (permalink / raw)
To: pgsql-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
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
@ 2015-03-13 11:40 Joshua D. Drake <jd@commandprompt.com>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
1 sibling, 1 reply; 12+ messages in thread
From: Joshua D. Drake @ 2015-03-13 11:40 UTC (permalink / raw)
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>; 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!
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
@ 2015-03-13 13:16 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 12+ messages in thread
From: Achilleas Mantzios @ 2015-03-13 13:16 UTC (permalink / raw)
To: pgsql-admin
On 13/03/2015 13:40, Joshua D. Drake wrote:
> 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.
Thanx Joshua.
If theoretically somehow we eliminate the power loss factor, would it make sense to use such a disk?
>
> JD
>
--
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
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
@ 2015-03-13 13:27 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
1 sibling, 1 reply; 12+ messages in thread
From: Scott Ribe @ 2015-03-13 13:27 UTC (permalink / raw)
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>; +Cc: pgsql-admin
On Mar 13, 2015, at 5:27 AM, Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
>
> What is your take on this? Is it dangerous to have PgSQL on this disk especially in cases of power outages?
Of course.
> (we have full UPS support, however nothing can be overlooked, anything can happen)
Yeah, had a hospital IT server room lose power to a whole rack. Redundant UPSs throughout the data center, but one rack not wired correctly, routine maintenance on 1 UPS took down the rack...
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
@ 2015-03-13 13:36 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 0 replies; 12+ messages in thread
From: Achilleas Mantzios @ 2015-03-13 13:36 UTC (permalink / raw)
To: pgsql-admin
On 13/03/2015 15:27, Scott Ribe wrote:
> On Mar 13, 2015, at 5:27 AM, Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
>> What is your take on this? Is it dangerous to have PgSQL on this disk especially in cases of power outages?
> Of course.
>
>> (we have full UPS support, however nothing can be overlooked, anything can happen)
> Yeah, had a hospital IT server room lose power to a whole rack. Redundant UPSs throughout the data center, but one rack not wired correctly, routine maintenance on 1 UPS took down the rack...
>
Thanks Scott
--
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
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
@ 2015-03-13 13:47 Scott Marlowe <scott.marlowe@gmail.com>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 1 reply; 12+ messages in thread
From: Scott Marlowe @ 2015-03-13 13:47 UTC (permalink / raw)
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>; +Cc: pgsql-admin
On Fri, Mar 13, 2015 at 7:16 AM, Achilleas Mantzios
<achill@matrix.gatewaynet.com> wrote:
> On 13/03/2015 13:40, Joshua D. Drake wrote:
>>
>> 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.
>
>
> Thanx Joshua.
>
> If theoretically somehow we eliminate the power loss factor, would it make
> sense to use such a disk?
Sadly there's no way to eliminate power loss in real life.
Now if you can live with some data loss corruption that's a different matter.
--
To understand recursion, one must first understand recursion.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
@ 2015-03-13 13:55 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 12+ messages in thread
From: Achilleas Mantzios @ 2015-03-13 13:55 UTC (permalink / raw)
To: pgsql-admin
On 13/03/2015 15:47, Scott Marlowe wrote:
> On Fri, Mar 13, 2015 at 7:16 AM, Achilleas Mantzios
> <achill@matrix.gatewaynet.com> wrote:
>> On 13/03/2015 13:40, Joshua D. Drake wrote:
>>> 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.
>>
>> Thanx Joshua.
>>
>> If theoretically somehow we eliminate the power loss factor, would it make
>> sense to use such a disk?
> Sadly there's no way to eliminate power loss in real life.
>
> Now if you can live with some data loss corruption that's a different matter.
Thanx,
the question is if postgresql will recover, we can tolerate some data loss,
but no total db corruption, equivalent to fsync=false, with the db unable to recover.
>
>
--
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
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
@ 2015-03-13 14:01 Scott Marlowe <scott.marlowe@gmail.com>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 1 reply; 12+ messages in thread
From: Scott Marlowe @ 2015-03-13 14:01 UTC (permalink / raw)
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>; +Cc: pgsql-admin
On Fri, Mar 13, 2015 at 7:55 AM, Achilleas Mantzios
<achill@matrix.gatewaynet.com> wrote:
> On 13/03/2015 15:47, Scott Marlowe wrote:
>>
>> On Fri, Mar 13, 2015 at 7:16 AM, Achilleas Mantzios
>> <achill@matrix.gatewaynet.com> wrote:
>>>
>>> On 13/03/2015 13:40, Joshua D. Drake wrote:
>>>>
>>>> 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.
>>>
>>>
>>> Thanx Joshua.
>>>
>>> If theoretically somehow we eliminate the power loss factor, would it
>>> make
>>> sense to use such a disk?
>>
>> Sadly there's no way to eliminate power loss in real life.
>>
>> Now if you can live with some data loss corruption that's a different
>> matter.
>
>
> Thanx,
> the question is if postgresql will recover, we can tolerate some data loss,
> but no total db corruption, equivalent to fsync=false, with the db unable to
> recover.
>
Sadly that is the exact thing that is likely to happen.
P.s. I worked in a BIG data center that lost all power. Three power
conditioners, three USPs and the switch for the diesel gen all blew
out at once. Lots of dbs that relied on never losing power were
corrupted and took days to recover most of their data and get back
online.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
@ 2015-03-13 14:31 Ryan Thompson <agyant@gmail.com>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 2 replies; 12+ messages in thread
From: Ryan Thompson @ 2015-03-13 14:31 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: Achilleas Mantzios <achill@matrix.gatewaynet.com>; pgsql-admin
Personally, I'd steer clear of Samsung desktop SSDs for anything
mission-critical. I've seen them get ripped apart by standard SATA
controllers as well as LSI MegaRAID. My rule of thumb is Samsung is okay as
long as we're using RAID 1.
For data loss, pick up a RAID controller card with BBU or capacitor-based
cache protection. That way, in the event of a total power failure, the data
integrity is maintained and simply continues writing to disk once power is
restored.
Best Regards,
On Fri, Mar 13, 2015 at 7:01 AM, Scott Marlowe <scott.marlowe@gmail.com>
wrote:
> On Fri, Mar 13, 2015 at 7:55 AM, Achilleas Mantzios
> <achill@matrix.gatewaynet.com> wrote:
> > On 13/03/2015 15:47, Scott Marlowe wrote:
> >>
> >> On Fri, Mar 13, 2015 at 7:16 AM, Achilleas Mantzios
> >> <achill@matrix.gatewaynet.com> wrote:
> >>>
> >>> On 13/03/2015 13:40, Joshua D. Drake wrote:
> >>>>
> >>>> 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.
> >>>
> >>>
> >>> Thanx Joshua.
> >>>
> >>> If theoretically somehow we eliminate the power loss factor, would it
> >>> make
> >>> sense to use such a disk?
> >>
> >> Sadly there's no way to eliminate power loss in real life.
> >>
> >> Now if you can live with some data loss corruption that's a different
> >> matter.
> >
> >
> > Thanx,
> > the question is if postgresql will recover, we can tolerate some data
> loss,
> > but no total db corruption, equivalent to fsync=false, with the db
> unable to
> > recover.
> >
>
> Sadly that is the exact thing that is likely to happen.
>
> P.s. I worked in a BIG data center that lost all power. Three power
> conditioners, three USPs and the switch for the diesel gen all blew
> out at once. Lots of dbs that relied on never losing power were
> corrupted and took days to recover most of their data and get back
> online.
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
@ 2015-03-13 15:59 Scott Marlowe <scott.marlowe@gmail.com>
parent: Ryan Thompson <agyant@gmail.com>
1 sibling, 0 replies; 12+ messages in thread
From: Scott Marlowe @ 2015-03-13 15:59 UTC (permalink / raw)
To: Ryan Thompson <agyant@gmail.com>; +Cc: Achilleas Mantzios <achill@matrix.gatewaynet.com>; pgsql-admin
On Fri, Mar 13, 2015 at 8:31 AM, Ryan Thompson <agyant@gmail.com> wrote:
> On Fri, Mar 13, 2015 at 7:01 AM, Scott Marlowe <scott.marlowe@gmail.com>
> wrote:
>>
>> On Fri, Mar 13, 2015 at 7:55 AM, Achilleas Mantzios
>> <achill@matrix.gatewaynet.com> wrote:
>> > On 13/03/2015 15:47, Scott Marlowe wrote:
>> >>
>> >> On Fri, Mar 13, 2015 at 7:16 AM, Achilleas Mantzios
>> >> <achill@matrix.gatewaynet.com> wrote:
>> >>>
>> >>> On 13/03/2015 13:40, Joshua D. Drake wrote:
>> >>>>
>> >>>> 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.
>> >>>
>> >>>
>> >>> Thanx Joshua.
>> >>>
>> >>> If theoretically somehow we eliminate the power loss factor, would it
>> >>> make
>> >>> sense to use such a disk?
>> >>
>> >> Sadly there's no way to eliminate power loss in real life.
>> >>
>> >> Now if you can live with some data loss corruption that's a different
>> >> matter.
>> >
>> >
>> > Thanx,
>> > the question is if postgresql will recover, we can tolerate some data
>> > loss,
>> > but no total db corruption, equivalent to fsync=false, with the db
>> > unable to
>> > recover.
>> >
>>
>> Sadly that is the exact thing that is likely to happen.
>>
>> P.s. I worked in a BIG data center that lost all power. Three power
>> conditioners, three USPs and the switch for the diesel gen all blew
>> out at once. Lots of dbs that relied on never losing power were
>> corrupted and took days to recover most of their data and get back
>> online.
>>
> Personally, I'd steer clear of Samsung desktop SSDs for anything
> mission-critical. I've seen them get ripped apart by standard SATA
> controllers as well as LSI MegaRAID. My rule of thumb is Samsung is okay as
> long as we're using RAID 1.
>
> For data loss, pick up a RAID controller card with BBU or capacitor-based
> cache protection. That way, in the event of a total power failure, the data
> integrity is maintained and simply continues writing to disk once power is
> restored.
That won't save you from SSDs that aren't safe if they lose power. The
problem is that the SSDs that don't have the ability to finish writes
when they lost power act as though they do. They respond positively to
fsync requests while not actually writing your data out to the memory
cells. So if you lose power, the RAID controller thinks that data is
already written when it's not.
Simple rule, avoid SSDs that don't have super caps or some other
method to write out your data safely in the event of a power failure.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
@ 2015-03-13 16:01 Fernando Hevia <fhevia@gmail.com>
parent: Ryan Thompson <agyant@gmail.com>
1 sibling, 1 reply; 12+ messages in thread
From: Fernando Hevia @ 2015-03-13 16:01 UTC (permalink / raw)
To: Ryan Thompson <agyant@gmail.com>; +Cc: Scott Marlowe <scott.marlowe@gmail.com>; Achilleas Mantzios <achill@matrix.gatewaynet.com>; pgsql-admin
On Fri, Mar 13, 2015 at 11:31 AM, Ryan Thompson <agyant@gmail.com> wrote:
> Personally, I'd steer clear of Samsung desktop SSDs for anything
> mission-critical. I've seen them get ripped apart by standard SATA
> controllers as well as LSI MegaRAID. My rule of thumb is Samsung is okay as
> long as we're using RAID 1.
>
> For data loss, pick up a RAID controller card with BBU or capacitor-based
> cache protection. That way, in the event of a total power failure, the data
> integrity is maintained and simply continues writing to disk once power is
> restored.
>
I am afraid that won't suffice. The HD will signal the controller that the
data has been committed safely - which we know is not the case - and the
controller cache data would be discarded to make room for new blocks.
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
@ 2015-03-13 17:05 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Fernando Hevia <fhevia@gmail.com>
0 siblings, 0 replies; 12+ messages in thread
From: Achilleas Mantzios @ 2015-03-13 17:05 UTC (permalink / raw)
To: pgsql-admin
On 13/03/2015 18:01, Fernando Hevia wrote:
>
>
> On Fri, Mar 13, 2015 at 11:31 AM, Ryan Thompson <agyant@gmail.com <mailto:agyant@gmail.com>> wrote:
>
> Personally, I'd steer clear of Samsung desktop SSDs for anything mission-critical. I've seen them get ripped apart by standard SATA controllers as well as LSI MegaRAID. My rule of thumb is
> Samsung is okay as long as we're using RAID 1.
>
> For data loss, pick up a RAID controller card with BBU or capacitor-based cache protection. That way, in the event of a total power failure, the data integrity is maintained and simply continues
> writing to disk once power is restored.
>
>
> I am afraid that won't suffice. The HD will signal the controller that the data has been committed safely - which we know is not the case - and the controller cache data would be discarded to make
> room for new blocks.
>
>
People,
thanks a lot for all your replies. I just hope I won't have to send the next message in this list in full panic mode.
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
^ permalink raw reply [nested|flat] 12+ messages in thread
end of thread, other threads:[~2015-03-13 17:05 UTC | newest]
Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-03-13 11:27 Samsung SSD 850 PRO 1T : any good for PostgreSQL? Achilleas Mantzios <achill@matrix.gatewaynet.com>
2015-03-13 11:40 ` Joshua D. Drake <jd@commandprompt.com>
2015-03-13 13:16 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2015-03-13 13:47 ` Scott Marlowe <scott.marlowe@gmail.com>
2015-03-13 13:55 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2015-03-13 14:01 ` Scott Marlowe <scott.marlowe@gmail.com>
2015-03-13 14:31 ` Ryan Thompson <agyant@gmail.com>
2015-03-13 15:59 ` Scott Marlowe <scott.marlowe@gmail.com>
2015-03-13 16:01 ` Fernando Hevia <fhevia@gmail.com>
2015-03-13 17:05 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2015-03-13 13:27 ` Scott Ribe <scott_ribe@elevated-dev.com>
2015-03-13 13:36 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
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