Re: Plug-pull testing worked, diskchecker.pl failed

On Mon, Oct 22, 2012 at 6:17 AM, Chris Angelico <rosuav(at)gmail(dot)com> wrote:
> After reading the comments last week about SSDs, I did some testing of
> the ones we have at work - each of my test-boxes (three with SSDs, one
> with HDD) subjected to multiple stand-alone plug-pull tests, using
> pgbench to provide load. So far, there've been no instances of
> PostgreSQL data corruption, but diskchecker.pl reported huge numbers
> of errors.

What did you do to look for corruption? That PosgreSQL succeeds at
going through crash-recovery and then starting up is not a good
indicator that there is no corruption.

Did you do something like compute the aggregates on pgbench_history
and compare those aggregates to the balances in the other 3 tables?

Cheers,

Jeff