On Mon, Nov 16, 2009 at 1:32 PM, Robert Schnabel <schnab...@missouri.edu> wrote: > > Ok, so you have sufficiently sparked my curiosity as to whether Diskeeper > will in any way cause Postgres to fail the power chord test. Unfortunately > I have some deadlines to meet so won't be able to test this out until later
Best time is during acceptance testing before deployment. Failing that testing it in production on the backup server so you can burn it to the ground and rebuild it on a saturday. Note that surviving the power plug being pulled doesn't PROVE your system will always do that. You can try to simulate the real mix of load and even replay queries when pulling the plug, only to find the one corner case you didnt' test in production when power is lost. The power cord plug can prove a system bad, but you're still somewhat "hoping" it's really good, with a high probability of being right. Which is why backup is so important. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
