On Mon, Oct 22, 2012 at 6:17 AM, Chris Angelico <rosuav@gmail.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