> On Apr 8, 2018, at 03:30, Craig Ringer <cr...@2ndquadrant.com> wrote:
> 
> These are way more likely than bit flips or other storage level corruption, 
> and things that we previously expected to detect and fail gracefully for.

This is definitely bad, and it explains a few otherwise-inexplicable corruption 
issues we've seen.  (And great work tracking it down!)  I think it's important 
not to panic, though; PostgreSQL doesn't have a reputation for horrible data 
integrity.  I'm not sure it makes sense to do a major rearchitecting of the 
storage layer (especially with pluggable storage coming along) to address this. 
 While the failure modes are more common, the solution (a PITR backup) is one 
that an installation should have anyway against media failures.

--
-- Christophe Pettus
   x...@thebuild.com


Reply via email to