On Mon, Oct 22, 2012 at 6:17 AM, Chris Angelico <ros...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
