What is your primary geographic location?

Mirroring the 2021 and 2022 survey results, respondents from EMEA (Europe, Middle East, Africa) account for almost half of all respondents, but this year APAC (Asia-Pacific) has increased to 20.3%, up 9.3 percentage points from last year (11%).

How long have you been using PostgreSQL?

According to DB engines, PostgreSQL’s popularity remains steady. Unsurprisingly, the number of new PostgreSQL users experimenting with the database for less than a year has grown from 6.1% in 2021 to 6.4% in 2022 and now 8.1% in 2023.

What is the main reason you choose to use PostgreSQL over other options?

This is the second year in a row that the #1 reason people choose PostgreSQL is because it’s open source (23.4%), up 4.1 percentage points from last year (19.3%). Feature set is the #2 highest ranked (15.1%), followed by reliability (12.4%), down 4.1 percentage points from last year (16.5%).

Interestingly, the reason why people choose PostgreSQL changes as the experience grows. Open source is the most important factor for choosing PostgreSQL for those who started using PostgreSQL in the past 5 years. Reliability and open source are important for those using PostgreSQL for 6-10 years. People using PostgreSQL between 11-15 years choose PostgreSQL because of its reliability.

Note: In 2023, we added features set and merged open source and license into one option.

Have you ever contributed to PostgreSQL?

Forty-four percent of PostgreSQL users with 15+ years of experience have contributed to PostgreSQL at least once. In fact, regardless of their experience, users across the board have contributed to the PostgreSQL community.

Note: The graph above combines data points from two questions, “Have you ever contributed to PG?” and “How long have you been using PG?”

Compared to one year ago, is PostgreSQL being used more or less in your organization?

A total of 51.2% of respondents said that PostgreSQL is being used more or a lot more today in their organizations than a year ago. Small and medium businesses (0-50 employees) continue to use PostgreSQL more today than one year ago.

How big is your team?

Almost half of respondents (44.1%) work in organizations with 50 or fewer employees. Regardless of the company's size, respondents reported usually working on a team of 2-10 people.

How would you define your personal and professional use case?

Seventy-three percent of respondents report using PostgreSQL for personal projects, while 94% use PostgreSQL at work. Forty percent use PostgreSQL for both personal and professional projects.

This year's top five results mirror those of 2022. App development and dashboarding remain in the top two spots for personal and professional use cases. The AI/Machine Learning category is new to the survey this year and seems to be gaining traction in the top six.

Which best describes the industry your organization is in?

In 2023, we added a few new options, Academia & Research, E-commerce, Government, Information Technology, Non-profit organization, and Security.

How would you rate your ability to connect with the PostgreSQL community?

In the last three years, connecting with the PostgreSQL community has become increasingly difficult. After looking at previous years, we noticed a slight tilt away from “extremely easy” responses to “medium.” This year has seen the most significant increase in medium responses (41.1%) compared to 2022 (36.2%). 888 out of 888 people answered this question.

In your experience, what’s the best thing about the PostgreSQL community / what do you like the most?

Over 489 respondents shared one or more aspects of the community they like the most. We have included a few responses below.

What are your top 3 favorite or most frequently used PostgreSQL extensions?

Respondents shared their favorite PostgreSQL extensions in this freeform question. The 2023 top 10 responses were quite different from the previous year, with several new extensions such as pg_fdw, pg_repack, and pg_cron making the list this time around.

What languages do you most frequently use to access PostgreSQL?

Consistent with responses from the previous two years, SQL, Python, Java, and JavaScript/TypeScript were cited as the most commonly used languages to access PostgreSQL. New to the top five list is Go. PostgreSQL users with 0-5 years of experience are more likely to use JavaScript or TypeScript than Java. Users with 6+ years of experience are more likely to use shell scripts to access the database than less experienced users.

Which of the following tools do you use most often to connect to PostgreSQL?

Responses to this question are consistent with results from 2022. The highest percentage of respondents said they use psql to connect to the PostgreSQL database. Other top answers include pgAdmin, DBeaver, Datagrip, and IntelliJ.

Note: Respondents could select as many options as desired.

What other third-party tools do you regularly use with PostgreSQL to assist with application development?

Almost half of the respondents (43.5%) said they do not use other third-party tools—of those who use one, Depesz EXPLAIN and pgBouncer were the most common responses.

Note: Respondents could select as many options as desired.

Which visualization tools do you use?

While 18% of respondents do not use visualization tools, of those who do, Grafana, pgAdmin, and DBeaver are still the tools they most likely use. These results are consistent with 2021 and 2022 responses.

Note: Respondents could select as many options as desired.

Do you currently use AI tools and what’s your attitude toward them?

It turns out that 45% of respondents have a favorable attitude toward AI tools, 35.2% are neutral, and only 19.7% have an unfavorable opinion. And even though there’s a higher number of favorable views, 36.9% say they are currently using AI tools in their workflow, versus the 63.1% that say they aren’t.

What are the main benefits you receive from using pgvector and PostgreSQL for AI/ LLM workloads?

Of those who responded yes to having used pgvector and PostgreSQL as your vector database for AI/ LLM workloads, a little over one-third (37.7%) said the main benefit is the ability to keep vector and relational data in the same database.

Note: Respondents could select as many options as desired.