Quick Links

Community
Contributors
Mailing Lists
IRC
Local User Groups
Events
International Sites

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.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.

Other Surveys

Which feature in PostgreSQL 11 are you most excited about?
Are you planning to test PostgreSQL 11 while it is in beta?
Do you like the redesign of the PostgreSQL.org website?
What PostgreSQL 10 Feature are you most excited about?
When are you planning to upgrade to PostgreSQL 9.6?
What Connection Proxy do you use for PostgreSQL?
What Configuration Management Framework do you use with your PostgreSQL server(s)?
What Web Framework do you use most often with PostgreSQL?
What External Programming Language do you use most often with PostgreSQL?
What is the smallest amount of RAM you have on a production PostgreSQL server?
What production OS do you use with PostgreSQL?
What's your favorite 9.3 feature?
Do you use a graphical tool to manage PostgreSQL?
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 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?
How large is your PostgreSQL database?
What's your primary use for PostgreSQL?
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?
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?