News for hackers. Stuff that matters.

A comment on How Postgres Makes Transactions Atomic. Parent comment

Re:How Postgres Makes Transactions Atomic by gnaritas on Wednesday August 16, 2017 @02:30PM (#15029909)
> Although if I had a $100 for every time I've had DB corruption in Postgres over the years...

You'd be broke. :)

[ Parent | on HN ]
Re:How Postgres Makes Transactions Atomic by random_comment on Wednesday August 16, 2017 @04:44PM (#15031220)
That probably depends on a bunch of stuff.

- PG only added checksums in 9.3

- his disks or RAID controller could be shit or he could be using some 'very cool' filesystem

- Some people turn off PG settings for performance that really shouldn't be turned off

- Some people think ECC ram isn't worth the money

- or overclock their CPU on anything other than a gaming machine

Usually it's shit hardware

https://wiki.postgresql.org/wiki/Corruption

[ Parent | on HN ]