The current results of our Which of these DBA mistakes has caused you the most downtime? survey are:
| Answer | Responses | Percentage |
|---|---|---|
| DELETE FROM {critical table} ... without "WHERE" | 39 | 15.17509727626459% |
| DROP DATABASE {production db} | 12 | 4.669260700389105% |
| DROP TABLE {critical table} | 3 | 1.1673151750972763% |
| kill -9 postgres | 18 | 7.003891050583658% |
| Upgrading PostgreSQL "in place" without migrating data | 28 | 10.894941634241246% |
| rm -rf pg_xlog/ | 6 | 2.3346303501945527% |
| UPDATE {critical table} ... without WHERE | 82 | 31.90661478599222% |
| I never make mistakes! I am human 0.2! | 69 | 26.848249027237355% |
| Total | 257 |
This survey was posted Aug. 18, 2009.