Обсуждение: Fwd: [PERFORM] Time to put theory to the test?
-------- Original Message --------
Subject: | [PERFORM] Time to put theory to the test? |
---|---|
Date: | Mon, 25 Apr 2011 14:30:59 -0500 |
From: | J Sisson <sisson.j@gmail.com> |
To: | pgsql-performance@postgresql.org <pgsql-performance@postgresql.org> |
Not sure if this is the right list...but: Disclaimer: I realize this is comparing apples to oranges. I'm not trying to start a database flame-war. I just want to say thanks to the PostgreSQL developers who make my life easier. I manage thousands of databases (PostgreSQL, SQL Server, and MySQL), and this past weekend we had a massive power surge that knocked out two APC cabinets. Quite a few machines rebooted (and management is taking a new look at the request for newer power cabinets heh). Talking theory is one thing, predicting results is another...and yet the only thing that counts is "what happens when 'worst-case-scenario' becomes reality?" Long story short, every single PostgreSQL machine survived the failure with *zero* data corruption. I had a few issues with SQL Server machines, and virtually every MySQL machine has required data cleanup and table scans and tweaks to get it back to "production" status. I was really impressed...you guys do amazing work. Thank you. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
I had exactly the same experience 3 years ago. Complete power failure (the stand-by generator took fire) in one small datacenter (around 500 machines). We had Oracle, SQL Server, DB2, MySQL, Progress, and of course PostgreSQL. The only database engine that restarted with no operation required was PostgreSQL. There were very minimal problems with Oracle (typing recover on some instances), but we had quite a few problems with the other engines. Le lundi 25 avril 2011 à 12:41 -0700, Joshua D. Drake a écrit : > > > -------- Original Message -------- > Subject: > [PERFORM] Time to put theory to the > test? > Date: > Mon, 25 Apr 2011 14:30:59 -0500 > From: > J Sisson <sisson.j@gmail.com> > To: > pgsql-performance@postgresql.org > <pgsql-performance@postgresql.org> > > > Not sure if this is the right list...but: > > Disclaimer: I realize this is comparing apples to oranges. I'm not > trying to start a database flame-war. I just want to say thanks to > the PostgreSQL developers who make my life easier. > > I manage thousands of databases (PostgreSQL, SQL Server, and MySQL), > and this past weekend we had a massive power surge that knocked out > two APC cabinets. Quite a few machines rebooted (and management is > taking a new look at the request for newer power cabinets heh). > Talking theory is one thing, predicting results is another...and yet > the only thing that counts is "what happens when 'worst-case-scenario' > becomes reality?" > > Long story short, every single PostgreSQL machine survived the failure > with *zero* data corruption. I had a few issues with SQL Server > machines, and virtually every MySQL machine has required data cleanup > and table scans and tweaks to get it back to "production" status. > > I was really impressed...you guys do amazing work. Thank you. >