--- title: "A Sneak Peek Into the State of PostgreSQL 2024" published: 2024-12-17T09:49:07.000-05:00 updated: 2025-08-04T05:51:56.000-04:00 excerpt: "The 2024 State of PostgreSQL survey report is out! Read its first findings. " tags: State of PostgreSQL, PostgreSQL authors: Ana Tavares, Melanie Savoia --- > **TimescaleDB is now Tiger Data.** Software trends may come and go, but PostgreSQL continues to be a bastion of resilience and innovation. With more than 35 years of active development under its belt, this relational database has established itself as a cornerstone of the open-source ecosystem—and as part of its community, we’re happy to celebrate it once more by sharing the results of the fifth edition of the State of PostgreSQL survey. 🎉 The _2024 State of PostgreSQL_ survey ran for two months (September 1 through October 31), and 688 people provided responses. If you answered our questions, shared the survey on social media, or sent it to a friend—thank you! Your support is everything to us.♥️ So, sit back and grab your beverage of choice as we highlight 2024’s trends in PostgreSQL adoption, usage, and community engagement. Drum roll, please. 🥁 Here are some key insights from the _2024 State of PostgreSQL_ survey: - **Decline in new user adoption:** There are fewer new PostgreSQL users. Only 4.1 % of respondents reported less than one year of experience with PostgreSQL, down from 8.1 % in 2023. - **AI tools on the rise:** 55.3 % of PostgreSQL developers now use AI tools, a sharp increase from 36.9 % in 2023. This highlights AI's growing role in development workflows. Check our State of PostgreSQL AI blog post to learn more about how PostgreSQL users are building with AI. - **Versatility across use cases:** 60 % of respondents use PostgreSQL for both personal and professional projects, a significant 20 % increase from last year. Curious about what else we uncovered? 👀 Read on for a comprehensive dive into the State of PostgreSQL in 2024, and don’t forget to [check out the full report](https://www.timescale.com/state-of-postgres/2024)! ✨ ****About the State of PostgreSQL**** __Timescale’s love for PostgreSQL, one of the world’s most advanced open-source databases with 35+ years of history, runs deep.__ [__We built our products on PostgreSQL__](http://www.timescale.com/?ref=timescale.com)__, we love__ [__enabling other developers to use this reliable technology__](https://www.timescale.com/developers?ref=timescale.com)__, and__ [__we wouldn’t exist without it and the extensibility it provides__](https://www.timescale.com/blog/scaling-postgresql-to-petabyte-scale/)__.__ __In 2019, Timescale launched the first State of PostgreSQL report, advancing our desire to provide greater insights into the vibrant and growing PostgreSQL user base. The report provides valuable insights into this great community, from whether respondents use PostgreSQL for work or personal projects (or both!) to their favorite PostgreSQL tools, features, and information sources. Following a one-year hiatus due to the pandemic, we resumed the annual survey in 2021.__ __This is the__ [__fifth State of PostgreSQL report__](https://www.timescale.com/state-of-postgres/2024)__. Check out the__ [__second__](https://drive.google.com/drive/folders/14elckaNv7FLKyWhzp3JKd3tH6PvI9F45?usp=sharing&ref=timescale.com)__,__ [__third__](https://s3.amazonaws.com/assets.timescale.com/resources/state_of_postgres/State_of_PostgreSQL_2022_Full_Report.pdf?ref=timescale.com)__, and__ [__fourth__](https://www.timescale.com/state-of-postgres/2023?ref=timescale.com) __report editions.__ ## The State of PostgreSQL 2024 Demographics Let’s start by finding out who are this year’s State of PostgreSQL respondents. ### What is your primary geographic location? ![A world map with the respondents geo location by percentage](https://timescale.ghost.io/blog/content/images/2024/12/SOP_2024_geo-location-1.png) For another year, respondents from **EMEA (Europe, Middle East, Africa)** dominated the survey, representing over half of all participants. **North America** remains steady at 25 %, while **APAC (Asia-Pacific)** saw a notable dip, dropping from 12 % to 7 %. These shifts underline PostgreSQL's stronghold in EMEA and opportunities for growth in APAC. ### How long have you been using PostgreSQL? ![A line graph on how long respondents have been using PostgreSQL](https://timescale.ghost.io/blog/content/images/2024/12/SOP2024_usage-time.png) Seasoned PostgreSQL users are on the rise. Respondents with **15+ years of experience** surged to 21 % from 11 % in 2023, while those with **10-15 years of experience** also saw an uptick. However, **new user adoption is declining sharply,** with users having less than two years of experience dropping from 23.8 % in 2023 to just 12.5 % this year. ### What is your current profession or job status? The top industries using PostgreSQL remain **Software/SaaS (21 %), Information Technology (18 %),** and **Finance/Fintech (18 %).** Healthcare/Pharmaceuticals entered the top five for the first time, highlighting PostgreSQL’s growing appeal in diverse fields. In terms of job roles, **Backend Software Developers (28 %), Fullstack Developers (16 %),** and **Database Administrators (12 %)** lead the way. ## The PostgreSQL Community ### How did you first find out about PostgreSQL? ![A bar graph on how respondents first found out about PostgreSQL. Work or colleague is #1.](https://timescale.ghost.io/blog/content/images/2024/12/SOP2024_first-find-out-postgresql.png) Workplace environments are becoming a primary introduction point for PostgreSQL, with 30 % of respondents reporting they learned about it from colleagues or work settings. This marks a small but steady increase over last year’s 28 %. Technical forums and online communities remain stable at 6 %, while 25 % of respondents—second only to workplace discovery—can’t recall where they first encountered PostgreSQL. ### Have you ever contributed to PostgreSQL? _**Note**: In 2024, we added Developer Relations to the multiple-choice options._ This year, the question "Have you contributed to PostgreSQL?" expanded to include multiple contribution options. While **58 % of respondents** reported no contributions, the remaining 42 % have engaged with PostgreSQL in diverse ways: - **Advocacy**: 17 % - **Bug reporting**: 16 % - **Hosting user groups or meetups**: 11 % - **Documentation**: 9 % These findings highlight the many ways developers contribute beyond just writing code, enriching the PostgreSQL ecosystem. ### How would you rate your ability to connect with the PostgreSQL community?  ![A bar graph displaying the respondents' take on their ability to connect with the PostgreSQL community](https://timescale.ghost.io/blog/content/images/2024/12/SOP2024-ability-to-connect-to-community.png) As opposed to last year’s numbers, respondents are finding it **slightly easier to connect to the community** than in previous years, with Medium (43 %) and Extremely easy (18 %) responses up by two percentage points from 2023. A total of 384 respondents answered bonus questions, shedding light on what they like the most about the PostgreSQL community: ### In your experience, what’s the best thing about the PostgreSQL community / what do you like the most? ![Three quotes from community members on the best thing about the PostgreSQL community](https://timescale.ghost.io/blog/content/images/2024/12/SOP2024_community-opinions.png) ## Ecosystem and Tools PostgreSQL’s ecosystem is one of its strongest assets, offering a rich array of tools and extensions that enhance its already robust feature set. This year’s survey explored which PostgreSQL features, complementary tools, and extensions resonate most with users. Here's what the PostgreSQL community highlighted in 2024. ### What is your favorite PostgreSQL feature? ![A word cloud of the community'es favorite PostgreSQL features](https://timescale.ghost.io/blog/content/images/2024/12/SOP2024_fav-feature.png) When asked about their favorite PostgreSQL features, respondents overwhelmingly pointed to **extensibility**, which remains PostgreSQL’s standout capability. This was followed by **JSON support**, prized for its flexibility in managing semi-structured data, and **replication**, a key enabler of high availability and fault tolerance. 👉 Interested in [PostgreSQL replication](https://www.timescale.com/learn/postgresql-database-replication-guide)? Check out our guide. ### What other tools do you use that complement PostgreSQL? ![A list with the answers to the question "What other tools do you use that complement PostgreSQL?" In order: TimescaleDB, Redis, pgBouncer, Patroni, AWS RDS, pgAdmin, PostGIS, Grafana, Barman, Docker, Kubernetes.](https://timescale.ghost.io/blog/content/images/2024/12/SOP2024-other-tools.png) Respondents highlighted the tools they most frequently use alongside PostgreSQL, with [**TimescaleDB**](https://github.com/timescale/timescaledb) emerging as the top choice for time-series and analytics workloads. This was followed by **Redis**, often used for caching and real-time applications, and **PgBouncer**, valued for its connection pooling capabilities. 👉 Get our [Support team’s advice on PgBouncer](https://www.timescale.com/blog/using-pgbouncer-to-improve-your-postgresql-database-performance/). ### What are your top three favorite or most frequently used PostgreSQL extensions? The top three PostgreSQL extensions this year demonstrate its versatility across industries and use cases. For the second consecutive year, [**PostGIS**](https://www.timescale.com/learn/postgresql-extensions-postgis) led the pack, favored for its advanced geospatial data capabilities. **Pg\_stat\_statements** remains a favorite for performance monitoring, while [**TimescaleDB**](https://github.com/timescale/timescaledb) rounds out the top three for its time-series database capabilities. 👉 Learn how to [optimize your queries with pg\_stat\_statements](https://www.timescale.com/blog/using-pg-stat-statements-to-optimize-queries/). ## Read the Report We hope you enjoyed this sneak peek of our _State of PostgreSQL 2024_ survey! If you’d like to learn more insights about the PostgreSQL community_,_ including why respondents chose PostgreSQL, where they go to find jobs requiring PostgreSQL experience, and [how they use AI with PostgreSQL](https://www.timescale.com/blog/ai-state-of-postgresql-2024), don’t miss our complete [_2024_ _State of PostgreSQL_ report](https://www.timescale.com/state-of-postgres/2024).  Finally, a genuine word of appreciation to all the remarkable partners who have collaborated with us on this survey and helped us capture the collective experience of developers using PostgreSQL: **Community members**: [Jimmy Angelakos](https://vyruss.org/computing/), [Andrew Atkinson](https://www.linkedin.com/in/andyatkinson/), [Ryan Booz](https://www.linkedin.com/in/ryanbooz/), [Software & Booz](https://www.softwareandbooz.com/), [Elizabeth Christensen](https://www.linkedin.com/in/elizabeth-garrett-christensen?lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base_contact_details%3BhMC98Y4mSqi4mp%2B8PBn4Fw%3D%3D), [Henrietta Dombrovskaya](https://www.linkedin.com/in/henrietta-dombrovskaya-367b26?lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base_contact_details%3B2GsMvizjSs21BHfoj03Aig%3D%3D), [Floor Drees](https://floor.dev/), [Stefan Fercot](https://pgstef.github.io/), [Douglas Hunley](https://github.com/hunleyd), [Gülçin Yıldırım Jelinek](https://www.linkedin.com/in/gulcinyildirim?lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base_contact_details%3BvOnSt0fQRlKOpC26iX6p7g%3D%3D), [Valeria Kaplan](https://www.linkedin.com/in/valeriakaplan?lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base_contact_details%3B4iExj06cSMuGxklmLGnTvQ%3D%3D), [Jan Karremans](http://www.jk-consult.nl/), [Philip Marks](https://www.linkedin.com/in/philipmarks?lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base_contact_details%3Bjah4K90WTnaLYWGn9bd7ng%3D%3D), [Doug Ortiz](https://www.linkedin.com/in/doug-ortiz-illustris?lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base_contact_details%3B7Y7fZ%2BnCRJiPBmXRkFBDeQ%3D%3D), [Tech Bits](https://www.youtube.com/@techbits-dougortiz), [Steven Pousty](https://www.techravenconsulting.com), [Anastasia Raspopina](https://www.linkedin.com/in/anastasia-raspopina/), [Daniel Sarosi](https://www.linkedin.com/in/daniel-sarosi-2197902?lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base_contact_details%3BhfhOegllSu%2BcWy2Mhz%2Fl%2Bw%3D%3D), Jeremy Schneider, [Stefanie Janine Stölting](https://www.linkedin.com/in/sjstoelting?lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base_contact_details%3Bht3v74mjQTu215t6vtOO2A%3D%3D), [Shaun Thomas](https://bonesmoses.org) **Companies**: [Aiven](https://aiven.io/), [Basedash](https://www.basedash.com/) [CYBERTEC](https://www.cybertec-postgresql.com/en/), [Data Bene](https://www.data-bene.io/en/), [DataCloudGaze](https://www.datacloudgaze.com/), [Data Egret](https://www.dataegret.com/), [Device Insight](https://device-insight.com/en/), [EDB](https://www.enterprisedb.com/), [KM.ON](https://www.kmon.net/), [Mark Gurry Associates](https://www.mga.com.au/), [Neon](https://neon.tech/), [ParadeDB](https://www.paradedb.com/), [PG Weekly](https://postgresweekly.com/), [Plotly](https://plotly.com/python/), [ProOpenSource](https://proopensource.eu/), [simplyblock](https://www.simplyblock.io/), [Tembo](https://tembo.io/), [Timbira](https://www.timbira.com.br/), [Trebellar](https://trebellar.com/), [United Manufacturing Hub](https://www.umh.app/), [Xata](https://xata.io/) **Communities**: Barcelona PostgreSQL User Groups, [Kadin Yazilimci](https://www.linkedin.com/in/kad%C4%B1n-yaz%C4%B1l%C4%B1mc%C4%B1-9b3a89275?lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base_contact_details%3Br30Zn%2FN2Q6O0JMoDGoY7NA%3D%3D), Madrid PostgreSQL User Groups, [PgDay CMH](https://github.com/hunleyd), [PG Day Chicago](https://www.meetup.com/Chicago-PostgreSQL-User-Group), [Prague PostgreSQL Meetup](https://www.meetup.com/prague-postgresql-meetup/events/) Thank you for amplifying our reach and enabling us to connect with more developers across various channels!