Postgres Pro
Downloads
Home   >   mailing lists

Re: Initdb --data-checksums by default - Mailing list pgsql-general

From Alex Ignatov
Subject Re: Initdb --data-checksums by default
Date
Msg-id 5717661B.90204@postgrespro.ru
Whole thread Raw
In response to Re: Initdb --data-checksums by default  (Andreas Joseph Krogh <andreas@visena.com>)
List pgsql-general
Tree view


On 20.04.2016 12:27, Andreas Joseph Krogh wrote:
På onsdag 20. april 2016 kl. 11:22:33, skrev Alex Ignatov <a.ignatov@postgrespro.ru>:
[snip]
Why do you think that common pg-users doesn't care about their data?
 
Did I say that?
 
Also why do we have wal_level=minimal fsync=on and other stuff?
 
To make certain garantees that data is by default durable.
 
What I'm saying is that everything is a compromise, cost/benefit. The universe might explode tomorrow but the chances are slim, so no use preparing for it.
Those caring enough probably use checksums, battery-packed RAID etc.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 

Wal is not durable without crc in it. But we have by default crc in wal and not in data files.
 
-- 
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
Attachment

pgsql-general by date:

Previous
From: Jinhua Luo
Date:
Subject: How does postgresql jdbc driver implement prepared batch?
Next
From: John R Pierce
Date:
Subject: Re: Initdb --data-checksums by default