Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Survey Results
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% |
| DROP DATABASE {production db} | 12 | 4% |
| DROP TABLE {critical table} | 3 | 1% |
| kill -9 postgres | 18 | 7% |
| Upgrading PostgreSQL "in place" without migrating data | 28 | 10% |
| rm -rf pg_xlog/ | 6 | 2% |
| UPDATE {critical table} ... without WHERE | 82 | 31% |
| I never make mistakes! I am human 0.2! | 69 | 26% |
| Total | 257 |
Other Surveys
- Do you apply all of the PostgreSQL Updates?
- What feature are you most excited about in 9.2?
- How soon do you plan to upgrade your production servers to 9.1?
- What cloud host do you run PostgreSQL on?
- Have you tried pg_upgrade?
- Which PostgreSQL 9.1 Feature Are You Most Excited About?
- Do you use SERIALIZABLE transaction mode?
- Which PostgreSQL event below are you most likely to go to in the next six months?
- What do you think of Hot Standby/Streaming Replication?
- When will you go into production with 9.0?
- What is your favorite non-replication feature of 9.0 Beta?
- Which of these non-relational databases do you use alongside PostgreSQL?
- How do you intend to use Hot Standby and Synch Rep in 9.0?
- How do you contribute to the PostgreSQL Project?
- Which Version 8.5 Alpha2 Feature have you tried?
- Which Version 8.5 Alpha1 Feature do you find most interesting?
- Which of these DBA mistakes has caused you the most downtime?
- How did you first hear about PostgreSQL?
- How do you use PostgreSQL?
- What's your highest priority for PostgreSQL development?
- How many PostgreSQL conferences and pgDays will you attend in 2009?
- Which PostgreSQL 8.4 Feature are you most excited about?
- What's your favorite PostgreSQL Replication Tool?
- Do you ever access the PostgreSQL System Catalogs?
- What was your first version of PostgreSQL?
- Do you live near a PostgreSQL User Group? (pugs.postgresql.org)
- What programming language do you use with PostgreSQL most often?
- What kind of application do you run on your primary/largest PostgreSQL server?
- How do you usually install & upgrade PostgreSQL?
- Which of the below TODOs would you most like to have?
- What version of PostgreSQL are you running on most of your production PostgreSQL servers?
- Which new PostgreSQL accessory feature are you most excited about?
- Which 8.3 core feature are you most excited about?
- What Operating System is your primary/largest production PostgreSQL database running on?
- When do you upgrade your PostgreSQL servers after a major release?
- Which conference are you most likely to attend?
- What desktop OS do you develop or manage your PostgreSQL databases from?
- Aside from PL/PgSQL, which procedural language do you use most often?
- What reporting products do you use with PostgreSQL?
- Where did you get your current production copy of PostgreSQL from?
- What feature are you most excited about in the upcoming 8.1 release?
- Should the PostgreSQL Community make a statement against the current European software patent initiative on our web site?
- How many PostgreSQL installation do you currently have?
- How are you using PostgreSQL for Windows?
- I would like the default font size on the new PostgreSQL website to be:
- How old are you?
- What is your most anticipated feature in 8.0?
- What is your preferred PostgreSQL administration tool?
- What database did you use before PostgreSQL?
- How long have you been using PostgreSQL?
- What would attract the most new PostgreSQL users?
- What version of PostgreSQL do you currently use?
- What platform do you primarily run PostgreSQL on?
- What programming language do you use with PostgreSQL the most?
- What's your primary use for PostgreSQL?
- How large is your PostgreSQL database?
- If there was an official newsgroup for postgresql, would you switch to using Usenet from using the mailing lists?
- Does your business utilise a PostgreSQL support company?
- Does your business utilise a PostgreSQL support company?
- What is your favourite source of PostgreSQL information and help?
- How do you pronounce 'PostgreSQL'?
- What licence do you normally use for your PostgreSQL applications?
- What is your favorite new feature of PostgreSQL 7.4?
- Should we create a standard worldwide PostgreSQL training course?
- How many users do your PostgreSQL installations serve?
- What PostgreSQL API do you use the most?
- What is your favorite PostgreSQL add-in feature?