What's in a Postgres major release? An analysis of contributions in the v17 timeframe | Claire Giordano | PGConf EU 2024

Slides from a conference presentation at PGConf EU 2024 in Athens Greece. Abstract: Have you ever wondered when code changed in a Postgres release was last modified? Or what the cycle time is for fixes: from when an idea is first discussed in the mailing list to when it lands in the Postgres core? Or who the contributors are—and how many of the code and doc contributors are doing their first-ever commit? What about non-code contributions in the 16-month Postgres 17 development timeframe... things like serving as conference organizers or on talk selection teams—or giving talks? And while we all know Postgres is a global project, where are all of these Postgres contributors from?

In this talk, you’ll walk through a brand new analysis—done by Postgres committer Daniel Gustafsson and Claire Giordano—of the contributions to Postgres in the v17 timeframe. The analysis will build on published blog posts such as the one Robert Haas publishes annually—and will leverage data sources such as the Postgres commit logs—and info about conference contributions, user groups, podcasts, and more. And there will be fun insights too, such as, what was the oldest piece of code that was replaced in PG 17?

Transcript

1. What’s in a Postgres major release? CLAIRE GIORDANO @clairegiordano • @PosetteConf • @AzureDBPostgres An analysis of contributions in v17 timeframe
2. @clairegiordano @clairegiordano@hachyderm.io Engineer Dev Manager PM Marketer Writer Open-source champion Community Lead Podcaster
3. Quite a lot of Postgres work @ Microsoft 3 Azure Database for PostgreSQL MANAGED DATABASE SERVICE fully-managed database service for Postgres NEW CAPABILITIES in FLEXIBLE SERVER “Flexible Server” 3 aka.ms/blog-pg-at-microsoft OPEN SOURCE WORK PostgreSQL core Contribute to PG open source (and review patches on many other people's work!) Citus Open Source Citus open-source extension to Postgres gives you Postgres at any scale. (Think: distributed Postgres.) PG Ecosystem Postgres extension & tooling our PG team at Microsoft maintains or contributed to in last ~8 months PG Community Contribute to growth & knowledge of the PostgreSQL open-source developer & user communities. @clairegiordano
4. PostgreSQL major contributor & committer PostgreSQL hacker @ Microsoft Organizer of Nordic PGDay (since 2014) PGConf NYC 2024 Talk Selection Team POSETTE 2024 & 2025 Talk Selection Team PGConf EU Organizing Committee 2014-2023 Daniel Gustafsson Collaborator & research partner on this Postgres 17 analysis
5. 5 Gratitude is a thing
6. @pgconfeu @pgconfeu@mastodon.social z z linkedin.com/showcase/pgconfeu WOW, THANK YOU to >140 people Organizers (9) Program Committee (6) Code of Conduct Team (3) Volunteers (36) Platinum Sponsors (4) Gold Sponsors (8) Silver Sponsors (12) Speakers (~66) +
7. 7 Building on top of Robert Haas’s annual Blog Post Source: rhaas.blogspot.com/2024/01/who-contributed-to-postgresql.html
8. In CY 2023 development, 90% of new lines of code were contributed by one of 50 people… Here are top 30 code authors in CY2023, from Robert Haas Jan 2024 post 8
9. But then Daniel Gustafsson & I started to wonder... Entire v17 development timeframe? Contributions beyond code? Shape, size, frequency of code commits? New code contributors? Unsung heroes? Interesting commits in PG 17? @clairegiordano
10. Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission. @clairegiordano PUBLISH
11. 11 Timeframe for Postgres 17 contribution analysis Jun 29, 2023* – end-of-Sept 2024 29 Jun 2023
12. Methodology, Sources, & Tooling This was a TON more work than Daniel and I expected: from collecting the data— deciding what to include & exclude—finding & fixing all the dups… Wading through this contribution data was like a never-ending buffet!” “ —Claire Giordano Dates data collected Tooling Manual vs. Automated Jul-Sep 2024 for Git Commit analysis: Ekorre github.com/danielgustafsson/ekorre • Other than Ekorre, extremely manual • Tedious deduplication of people’s names Sources: Online, public information, e.g. • Git Commit logs • PostgreSQL.org • Mailing lists • Conference Websites • Meetup pages • LinkedIn • Planet Postgres RSS Feed
13. PUBLISH • Boards of Directors • Code of Conduct • Core Team • Event Organizers • Event Talk Selection • Event Volunteers • Moderators • Teams/ Committees • User Groups @clairegiordano
14. Q: What are the Recognized Postgres Non-Profit Organizations (NPOs)? PgEU PGCA Slonik Events Canada @clairegiordano
15. PGCA Q: Who are the 16 people who serve on the 21 Board seats for the Recognized Postgres non-profits? Slonik Events Canada PGCA Board • Dave Page • Steve Singer • Jonathan Katz • Jaime Casanova • Peter Eisentraut • Marc Fournier • Claire Giordano PgUS Board • Elizabeth Garrett Christensen • Stacey Haysler • Jonathan Katz • Mark Wong PgEU Slonik Events Canada Board • Jonathan Katz • Steve Singer • Daniel Gustafsson • Magnus Hagander • Paul Ramsey PGEU Board: • Magnus Hagander • Andreas Scherbaum • Lætitia Avrot • Karen Jex • Dave Page
16. Q: Who are 23+ Volunteers who served on 7+ Code of Conduct Committees? in v17 timeframe Special shout-out to Code of Conduct Committee for THIS 2024 conference: Stacey Haysler // Ilya Kosmodemiansky // Pavlo Golub Event-specific Code of Conduct Committees, v17 timeframe PGDay UK 2023 Vik Fearing Devrim Gündüz Lætitia Avrot PGConf EU 2023 Vik Fearing Stacey Haysler Stefanie Janine Stölting pgDay Paris 2024 Floor Drees Karen Jex Stefan Fercot POSETTE 2024 Teresa Giacomini Ahmet Eren Başak Aaron Wislang PGDay UK 2024 Floor Drees Pavlo Golub PGDay Lowlands Floor Drees Jos van Schouten Sarah Conway 3 3 3 3 2 3 PostgreSQL Code of Conduct Committee as of 7 Jul 2024 Aleksandra Abramova Chris Travers Sergei Kim Simon Pane 4 6Anthony Nowocien Eliza Bennett Ilaria Battiston Lucie Šimečková Michael Goldberg Stefan Fercot Past members in the v17 timeframe:
17. Q: Who serves on the PostgreSQL Core Team? Peter Eisentraut Andres Freund Magnus Hagander Jonathan Katz Tom Lane Bruce Momjian Dave Page
19. PGDay at FOSSASIA Summit 2024 PostgreSQL Conference Japan 2023 PGDay Hyd 2024 PGConf India 2024 PostgreSQL @ SCaLE21x PGConf.dev 2024 PGDay Chicago 2024 PGCon 2023 PGConf NYC 2024 PGConf NYC 2023 PG BootCamp Russia 2023 PGConf EU 2023 PG BootCamp Minsk 2024 Prague PostgreSQL Developer Day 2024 Nordic PGDay 2024 PostgreSQL Conference Germany 2024 Swiss PGDay 2023 Swiss PGDay 2024 PGDay UK 2024 PGDay UK 2023 pgDay Paris 2024 FOSDEM PGDay 2024 PGDay Belgium 2024 Postgres Ibiza 2024 PGDay France 2024 PGDay Lowlands 2024 VIRTUAL POSETTE: An Event for Postgres 2024 VIRTUAL PostGIS Day 2023 PASS Data Community Summit 2023 @clairegiordano Q: Where were ~29 Postgres Conferences? v17 timeframe Missing: FOSS4G events, Postgres Conference Silicon Valley, Brazil/Postgres events, Japan Unconference events, Postgres Madagascar event, Kazan Bootcamp event.
20. PostgreSQL Conference Japan 2023 Q: Is there a Postgres Conference “season”? PGCon 2023 PG BootCamp Russia 2023 Swiss PGDay 2023 PGConf NYC 2023 PGDay UK 2023 PostGIS Day 2023 PASS Data Community Summit 2023 PGConf India 2024 FOSDEM PGDay 2024 PostgreSQL @ SCaLE21x PGConf EU 2023 pgDay Paris 2024 PG BootCamp Minsk 2024 PostgreSQL Conference Germany 2024 PGDay at FOSSASIA Summit 2024 POSETTE: An Event for Postgres 2024 PGDay France 2024 Prague PostgreSQL Developer Day 2024 Swiss PGDay 2024 Nordic PGDay 2024 PGDay UK 2024 PGDay Lowlands 2024 Postgres Ibiza 2024 PGDay Hyd 2024 End-of- May+Jun PGConf.dev 2024 PGConf NYC 2024 PGDay Belgium 2024 Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep PGDay Chicago 2024 @clairegiordano
21. How many people served in conference organizing roles? > v17 timeframe, 29 events > including Talk Selection Teams (i.e. Program Committees) 21 74 31 10 9 1 3 2 0 20 40 60 80 1 2 3 4 5 6 7 Number of Organizers # of Conferences Organized per Organizer 239 Organizing Roles for 29 conferences done by 130 People (v17 timeframe) 6 people served on 5 or more organizing & talk selection teams!
22. Q: Who are 6 people who served on 5+ Organizing & Talk Selection Teams? for Postgres Conferences, v17 timeframe Chris Ellis Daniel Gustafsson Jonathan Katz Vik Fearing Magnus Hagander 5+ Daniel Westermann Dave Page Floor Drees 4 Andreas Scherbaum Boriss Mejías Carole Arnaud Dan Langille 3 Karen Jex Paul Ramsey Pavlo Golub Tomas Vondra Stefan Keller Stephan Wagner Devrim Gündüz Mark Wong Melanie Plageman Michael Goldberg Pat Wright Stefanie Janine Stölting Tobias Bussmann @clairegiordano
23. Q: Who served on Postgres committees? Unsung Heroes: Important volunteer work you might NOT know about Christoph Berg Joe Conway Melanie Plageman Committee: Contributors Committee: Sponsors Dave Page Ilya Kosmodemiansky Jonathan S. Katz Robert Treat Tatsuo Ishii Andreas Scherbaum Dave Cramer Dave Page David Fetter Devrim Gündüz Granthana Biswas Greg Sabino Mullane Hans-Jürgen Schönig Joe Conway Jonathan S. Katz Lætitia Avrot Larry Rosenman Marc Fournier Mark Wong Michael Meskes Noah Misch Oleg Bartunov Peter Eisentraut Renee (Phillips) Huinker Robert Treat Valeria Kaplan Vik Fearing Committee: Funds Group @clairegiordano
24. 243/1 Hamburg PostgreSQL User Group 1,058 /17 Dallas/Fort Worth Postgres 1,506/14 Chicago PostgreSQL Meetup Group 765/13 Seattle Postgres User Group SEAPUG 477/11 Boston PostgreSQL Users Group 2,020/10 The San Francisco Bay Area PostgreSQL Meetup Group 278/8 Portland Postgres Users Group PDXPUG 3,457/7 NYC Postgres 879/6 Hyderabad PostgreSQL User Group 558/6 Prague PostgreSQL Meetup 319/5 PgBE PostgreSQL Users Group Belgium 464/5 pgCMH: Columbus PostgreSQL Users Group 91/5 Kansas City Postgres User Group 888/4 PostgreSQL User Group NL 523/4 Meetup PostgreSQL Lille 1,602/4 PostgreSQL Meetup Group Berlin 1,106/4 PostgreSQL Espana 104/3 PostgreSQL User Group NRW 1040/3 Indonesia PostgreSQL User Group 2,394/3 Islamabad PostgreSQL User Group 131/3 Triangle Postgres Users Group 310/2 Postgres User Group Frankfurt (am Main) XXX/2 PostgreSQL Korea 107/5 Swiss PostgreSQL Users Group 1,273/2 Philly Postgres 654/1 PostgreSQL Curitiba 367/1 Toronto Postgres User Group 30/1 PostgreSQL User Group Estonia 283/1 PostgreSQL Lyon User Group 858/1 PostgreSQL User Group Paris 2505/10 Japan PostgreSQL User Group (JPUG) XXX/1 PostgreSQL México 185/1 Oslo PostgreSQL User Group 128/1 Barcelona PostgreSQL User Groupo 84/1 Madrid PostgreSQL User Group 282/1 Dubai PostgreSQL User Group 1,454/1 London PostgreSQL Meetup Group 427/1 pg_atl - PostgreSQL in Atlanta 468/1 Austin Postgres User Group 1,087/1 Bangalore PostgreSQL User Group * Q: Where did Postgres User Groups meet? v17 timeframe @clairegiordano
25. • Books • Blog Posts • Conference Talks • Newsletters • Person of Week • Podcasts • Social Media posts • User Group Talks • Videos & Demos PUBLISH @clairegiordano
26. Something about Books! @clairegiordano
27. Q: How many blog posts syndicated to Planet Postgres? v17 timeframe >>>>>> more than 1,000 posts / 173 authors # Posts # Posts Syndicated to Planet Postgres each month 63 79 77 68 60 70 70 87 91 81 68 68 67 71 71 Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep 2023 2024 100 80 60 40 20 0
28. Q: Who syndicated most blog posts to Planet Postgres? v17 timeframe. Excludes many other Postgres blog posts outside of Planet. Author
29. Q: How many speakers & talks at 29 conferences? v17 timeframe 255 63 30 22 12 5 1 2 3 3 1 0 50 100 150 200 250 300 1 2 3 4 5 6 7 8 9 10 14 # of Speakers # of Talks Given per Speaker 255 people gave 1 talk each 15 people gave 6 or more talks 397 Speakers gave 743 Talks at 29 Conferences, v17 timeframe @clairegiordano
30. 15 prolific Postgres Conference Speakers Out of 29 Postgres conferences in v17 timeframe Speaker Company # Talks Ryan Booz Redgate 14 Christophe Pettus PGX 10 Claire Giordano Microsoft 10 Pavlo Golub Cybertec 10 Bruce Momjian EDB 9 Jonathan S. Katz AWS 9 Tomas Vondra EDB/Microsoft 9 Frank Pachot Yugabyte 8 Karen Jex Crunchy Data 8 Magnus Hagander RedPill Linpro 7 Boriss Mejías EDB 6 Derk van Veen Adyen 6 Henrietta Dombrovskaya DRW 6 Luigi Nardi DBtune 6 Robert Haas EDB 6 Amit Kapila Fujitsu 5 Andrey Borodin Yandex Cloud 5 Chris Ellis Nexteam 5 Daniel Westermann dbi-services 5 Devrim Gündüz EDB 5 Grant Fritchey Redgate 5 Gülçin Yildirim Jelinek xata 5 Ilya Kosmodemiansky Data Egret 5 Jeremy Schneider AWS 5 Jimmy Angelakos Deriv 5 Lætitia Avrot EDB 5 Melanie Plageman Microsoft 5 Alexander Kukushkin Microsoft 4 Arda Aytekin Microsoft 4 Charles Feddersen Microsoft 4 Chelsea Dole Brex/Citadel 4 Chris Travers Delivery Hero 4 David Wheeler NYT/Tembo 4 Dirk Krautschick Aiven 4 Divya Sharma AWS 4 Gianni Ciolli EDB 4 Hans-Jürgen Schönig Cybertec 4 Heikki Linnakangas Neon 4 Jelte Fennema-Nio Microsoft/Motherduck 4 Joe Conway AWS 4 Krishnakumar Ravi Microsoft 4 Laurenz Albe Cybertec 4 Marion Baumgartner Camptocamp 4 Matt Cornillon Aiven/Google 4 Michaël Paquier AWS 4 Stefan Fercot EDB/Data Egret 4 Stephen Frost Noblis 4 Umair Shahid Stormatics 4 Varun Dhawan Microsoft 4 @clairegiordano
31. Armenia 1 Australia 4 Belgium 5 Brazil 4 Canada 16 Chile 1 Czechia 6 Estonia 1 Finland 1 France 23 Germany 28 India 52 Indonesia 2 Israel 2 Italy 7 Jamaica 1 Japan 15 Lithuania 1 Mexico 2 New Zealand 1 Norway 2 Pakistan 3 Poland 3 Portugal 1 Russia 11 Scotland 1 Ireland 1 Singapore 6 Spain 10 Sweden 5 Switzerland 16 Taiwan 2 Turkey 6 UK 15 Ukraine 1 USA 117 Vietnam 2 UNKNOWN 8 Q: What 39 countries were 397 Postgres Conference speakers from? V17 timeframe, limited to 29 PG conferences listed on PostgreSQL.org Netherlands 12 Austria 2
32. What Companies do the 437 speakers work at? *v17 timeframe as of Sep 2024 32 AWS, 12% Microsoft, 8% EDB, 7% self, 3% Google, 3% Crunchy Data, 3% Percona, 3% Cybertec, 2% NTT Group, 2% Fujitsu, 2% Camptocamp, 2% pgEdge, 1% Tembo, 1% Tantor Labs, 1% Aiven, 1% So many companies, 1%
33. Postgres Weekly newsletter Published by Cooperpress, edited by Peter Cooper, & super valuable! postgresweekly.com @clairegiordano
34. PostgreSQL Person of the Week ~19 people contributed interviews in v17 timeframe • Vasilis Ventirozos • Nicolas Payart • Andrew Atkinson • Sarah Conway • Philippe Noël • Amul Sul • Ozgun Erdogan • Grant Zhou • Dilip Kumar • Derk van Veen • William Ivanski • Philip Marks • Nazir Bilal Yavuz • Jonah H. Harris • Grant Fritchey • Florent Jardin • Artur Zakirov • Divya Sharma • Afsane Anand Created by the amazing Andreas Scherbaum postgresql.life @clairegiordano
35. scalingpostgres.com postgres.fm TalkingPostgres.com 35 Something about Podcasts! 20 episodes... monthly 111 episodes... weekly 330 episodes... weekly 20 episodes... 2 seasons @clairegiordano
36. Also, shout-out: 5mins of Postgres by Lukas Fittl @clairegiordano
37. 37 Q: What about Social posts? User Group talks? Videos? Bad News this data was not collected & not included in this analysis Good News LOTS of Postgres posts on social media + User Group talks presented + demos/videos on YouTube
38. • Discord • IRC • Mailing Lists • Mentoring • Slack • Stack Overflow • Telegram PUBLISH @clairegiordano
39. Q: Are Postgres mailing lists still a primary way to engage? Yes! Mailing List Total # Emails (v17 timeframe) pgsql-hackers 35,115 pgsql-docs 1,191 pgsql-general 6,704 pgsql-bugs 4,462 postgresql.org/list/
40. From Tomas Vondra keynote @ Swiss PGDay 2024 “The past and the future of the PostgreSQL community” Source: vondra.me/posts/the-state-of-the-postgres-community/ Tomas Vondra
41. Where do people engage with each other ONLINE? 41 EMAIL CHAT+Q&A Q&A SOCIAL MEDIA PLACES TO ENGAGE
42. Q: How can code contributors get MENTORING? [shout-out: new initiative in v17 timeframe] Robert Haas 10 mentors (PG committers) 15 mentees (PG committers) 716 people in Discord server Andreas Scherbaum Melanie Plageman FROM ROBERT HAAS BLOG
43. Q: How to join Discord Server for “PostgreSQL Hacker Mentoring”? SELECT string_agg(chr(c+46),'') FROM unnest(array[58,70,70,66,69,12,1,1,54,59, 69,53,65,68,54,0,57,57,1,52,74,4,25,11, 29,41,75,68,43]) AS c
44. • Build Farms • Code Authors • Committers • Docs • Extensions • Packaging • Patch Review • Security Team • Test Infra • Translations • Web Team PUBLISH @clairegiordano
45. Q: How much changed in Postgres 17? PG17 ~16 months of changes 2,680 total commits 232 Code/Doc authors 35,115 pgsql-hackers mailing list posts 3,957 (51%) files changed > 400K lines of code changed, out of ~700K total
46. Q: How big were Commits by # Lines Changed? No lines 1 2-10 1-25 26-100 101-250 251-500 3 0 200 400 600 800 Number of commits # Lines Changed in Postgres 17 Commits Number of lines changed 501-1,000 > 1,000 316 636 427 695 354 103 76 70
47. 47 Q: What is “cycle time” for commits—time between 1st email discussion & commit to PG17? 220 476 171 201 640 265 370 56 # days from 1st email to commit Same day 1-7 days 8-14 days 15-30 days 31-180 days 181-365 days 1-5 years 5+ years Number of commits Distribution of commits by pgsql-hackers email cycle time 0 200 400 600 800
48. Q: When was the code changed in PG17 last modified? Year PG17-modified lines of code last edited Year lines of code last modified 0 20,000 40,000 60,000 2024 2023 2022 2021 2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003 2002 2001 2000 1999 1998 1997 1996 Number of lines @clairegiordano
49. 49 Q: Who contributed code & docs to Postgres v17? 232 Aidar Imamov Ajin Cherian Aleksander Alekseev Alena Rybakina Alex Hsieh Alex Shulgin Alexander Korotkov Alexander Kuzmenkov Alexander Lakhin Alexander Pyhalov Álvaro Herrera Amit Kapila Amit Langote Amul Sul Anastasia Lubennikova Anatoly Zaretsky Andreas Karlsson Andrei Lepikhov Andrei Zubkov Andres Freund Andrew Atkinson Andrew Dunstan Andrey Borodin Andy Fan Anthonin Bonnefoy Anton A. Melnikov Anton Kirilov Anton Voloshin Antonin Houska Ants Aasma Artur Zakirov Ashutosh Bapat Ashutosh Sharma Atsushi Torikoshi Ayush Tiwari Ayush Vatsa Bernd Helmle Bertrand Drouvot Bharath Rupireddy Bo Anderson Bowen Shi Boyu Yang Bruce Momjian Cary Huang Christoph Berg Christoph Heiss Christophe Courtois Corey Huinker DaeMyung Kang (CharSyam) Dagfinn Ilmari Mannsåker Damir Belyalov Daniel Gustafsson Daniel Vérité Dave Cramer David G. Johnston David Geier David Rowley David Steele David Wheeler David Zhang Dean Rasheed Denis Erokhin Dilip Kumar Dmitry Dolgov Dmitry Koval Dongming Liu Egor Rogov Ekaterina Kiryanova Elena Indrupskaya Elizabeth Christensen Emre Hasegeli Eric Radman Erik Rijkers Erik Wienhold Etsuro Fujita Euler Taveira Fei Changhong Flavien Guedez Floris Van Nee Francesco Degrassi Fujii Masao Gabriele Bartolini Garrett Thornburg Gilles Darold Greg Sabino Mullane Greg Stark Gurjeet Singh Hajime Matsunaga Heikki Linnakangas Hongxu Ma Hou Zhijie Hubert Depesz Lubaczewski Ian Ilyasov Ian Lawrence Barwick Jacob Champion Jakub Wartak James Coleman Japin Li Jeevan Chalke Jeff Davis Jeff Janes Jelte Fennema-Nio Jian Guo Jian He Jim Jones Jingtang Zhang Jingxian Li Joe Conway John Ekins John Hsu John Morris John Naylor Jonathan S. Katz Joseph Koshakow Josh Kupershmidt Joshua D. Drake Jubilee Young Julien Rouhaud Junwang Zhao Justin Pryzby Kambam Vinay Karina Litskevich Kartyshov Ivan Kim Johan Andersson Kirk Wolak Konstantin Knizhnik Krishnakumar Ravi Kuntal Ghosh Kuroda Hayato Kuwamura Masaki Kyotaro Horiguchi Laurenz Albe Li Japin Magnus Hagander Martín Marqués Masahiko Sawada Masahiro Ikeda Matheus Alcantara Mats Kindahl Matthias van de Meent Maxim Orlov Melanie Plageman Melih Mutlu Michael Banck Michael Paquier Michael Zhilin Michail Nikolaev Mikhail A. Gribkov Miroslav Bendik Moaaz Assali Nathan Bossart Nazir Bilal Yavuz Nikhil Benesch Nikita Glukhov Nikolay Samokhvalov Nikolay Shaplov Nishant Sharma Noah Misch Noriyoshi Ole Peder Brandtzæg Oleg Bartunov Oleg Sibiryakov Oleg Tselebrovskiy Orlov Aleksej Palak Chaturvedi Paul A. Jungwirth Paul Amonson Pavel Borisov Pavel Luzanov Pavel Stěhule Pavlo Golub Peter Eisentraut Peter Geoghegan Peter Smith Philipp Warner Quan Zongliang Ranier Vilela Reid Thompson Rian McGuire Richard Guo Robert Haas Robert Treat Roberto Mello Ronan Dunklau Rui Zhao Ryoga Yoshida Sameer Kumar Sami Imseih Satoru Koizumi Sergei Kornilov Sergey Sargsyan Sergey Shinderuk Shihao Zhong Shinoda Shinya Kato Shlok Kyal Shruthi Gowda Shubham Khanna Shveta Malik Soumyadeep Chakraborty Stepan Rutz Steve Chavez Suraj Kharage Sutou Kouhei suyu.cmj Svetlana Derevyanko Tatsuo Ishii Tatsuro Yamada Tender Wang Teodor Sigaev Thomas Munro Tim Needham Tom Lane Tomas Vondra Tommy Pavlicek Tomonari Katsumata Tristan Partin Tung Nguyen Vignesh C Vik Fearing Vinayak Pokale Wang Wei Will Mortensen Willi Mann Wolfgang Walther Xing Guo Yongtao Huang Youichi Aramaki Yugo Nagata Yura Sokolov Yurii Rashkovskii Zhang Mingli
50. 50 Q: Are any of the 232 code authors = NEW, first- time code contributors? 61 Aidar Imamov Alena Rybakina Alex Hsieh Anatoly Zaretsky Andrew Atkinson Anthonin Bonnefoy Anton Kirilov Ayush Tiwari Ayush Vatsa Bo Anderson Bowen Shi Boyu Yang Damir Belyalov Denis Erokhin Elizabeth Christensen Eric Radman Erik Wienhold Flavien Guedez Francesco Degrassi Garrett Thornburg Hajime Matsunaga Hongxu Ma Ian Ilyasov Jingtang Zhang Jingxian Li John Ekins John Morris Jubilee Young Junwang Zhao Kambam Vinay Kim Johan Andersson Krishnakumar Ravi Kuwamura Masaki Michael Zhilin Mikhail A. Gribkov Moaaz Assali Nishant Sharma Ole Peder Brandtzæg Oleg Sibiryakov Orlov Aleksej Palak Chaturvedi Paul Amonson Rian McGuire Ryoga Yoshida Sameer Kumar Satoru Koizumi Sergey Sargsyan Shihao Zhong Shlok Kyal Shubham Khanna Shveta Malik Sutou Kouhei suyu.cmj Svetlana Derevyanko Tim Needham Tommy Pavlicek Tung Nguyen Willi Mann Yongtao Huang Youichi Aramaki Yurii Rashkovskii
51. 51 Q: How many commits did each of 232 code/doc authors make? 27 people contributed more than 25 commits each—totaling >2,000 commits!
52. Richard Guo OpenPie/EDB 48 Andrew Dunstan EDB 43 John Naylor self 41 Noah Misch Google 40 Bharath Rupireddy AWS 37 Melanie Plageman Microsoft 36 Tomas Vondra EDB/Microsoft 36 Hou Zhijie Fujitsu 35 Masahiko Sawada AWS 33 Jelte Fennema-Nio Microsoft/Motherduck 30 Kuroda Hayato Fujitsu 25 Peter Smith Fujitsu 25 Q: Who are 27 code authors who contributed 25 or more commits in v17? Code Authors Company Total # Commits Peter Eisentraut EDB 281 Tom Lane Crunchy Data 242 Heikki Linnakangas Neon 141 Michael Paquier AWS 140 Bruce Momjian EDB 114 Alexander Korotkov Oriole/Supabase 106 Álvaro Herrera EDB 99 David Rowley Microsoft 85 Nathan Bossart AWS 81 Thomas Munro Microsoft 77 Daniel Gustafsson Microsoft 67 Robert Haas EDB 65 Amit Langote EDB/Microsoft 61 Andres Freund Microsoft 59 Jeff Davis AWS 59
53. 53 Q: How many people involved per commit? We don’t know. But we do know the # of people mentioned in each of 2,680 commits 1 2 3 4 5 6 to 10 >10 19 143 139 327 536 507 1009 0 250 500 750 1000 # of commits Distribution of Commits by # of People Mentioned # of people mentioned
54. Q: What countries are 232 code authors from? v17 timeframe. Only found country data for 145/232 authors = ~62% Brazil 1 Spain 2 USA 33 Canada 5 Australia 2 Russia 17 Taiwan 2 China 12 Thailand 1 India 7 UK 2 France 6 Netherlands 5 Italy 1 Sweden 4 Finland 1 Norway 1 Estonia 1 Czechia 2 Germany 10 Lithuania 1 Ukraine 2 Turkey 2 Israel 1 Armenia 1 Poland 2 Cyprus 1 Singapore 1 Japan 15 Korea 1 New Zealand 2 Austria 1 @clairegiordano
55. Q: How many Postgres committers are there? 30 Bruce Momjian Tom Lane Tatsuo Ishii Peter Eisentraut Joe Conway Álvaro Herrera Andrew Dunstan Magnus Hagander Heikki Linnakangas Robert Haas Jeff Davis Fujii Masao Noah Misch Andres Freund Dean Rasheed Alexander Korotkov Amit Kapila Tomas Vondra Michael Paquier Thomas Munro Peter Geoghegan Etsuro Fujita David Rowley Daniel Gustafsson John Naylor Nathan Bossart Amit Langote Masahiko Sawada Melanie Plageman * Richard Guo * git shortlog -s 5bcc7e6dc8..d7ec59a63d
56. Amit Kapila 102 96 94.1% Michael Paquier 328 216 65.9% Daniel Gustafsson 117 56 47.9% Alexander Korotkov 163 78 47.9% David Rowley 111 43 38.7% Tomas Vondra 49 18 36.7% Robert Haas 91 33 36.3% Masahiko Sawada 42 15 35.7% Nathan Bossart 113 40 35.4% Alvaro Herrera 125 44 35.2% Bruce Momjian 156 47 30.1% Amit Langote 64 19 29.7% Andres Freund 54 16 29.6% Tom Lane 296 81 27.4% Heikki Linnakangas 158 38 24.1% Andrew Dunstan 46 11 23.9% Q: How many commits done on behalf of others? v17 timeframe Total # commits as committer Commits on behalf of others* Footnotes* • 40 or more commits • 20% or more on behalf of others • “Behalf of others” = not Sole Author; other authors involved
57. Q: What is oldest code replaced in PG 17? 150 lines from Marc Fournier’s Postgres95 import were removed or modified in PG17! Marc Fournier
58. Q: Who Changed Oldest “Tom Lane Code”? Jelte Fennema-Nio Álvaro Herrera
59. Q: What is oldest email referred to in a v17 commit? Jan 2024 commit by Alexander Korotkov referenced 2007 email from the late Simon Riggs Add new COPY option ON_ERROR ignore Authors: Damir Belyalov, Atsushi Torikoshi, Alex Shulgin, Jian He Simon Riggs 8.4
60. Q: What is the longest email thread tied to commits in Postgres 17? 23 commits by Amit Kapila reference this email >> “Logical replication enhancements: failover control” 2021 – 10 – 31. 10:08:18 947 emails in this thread
61. Q: Are there more contributions in this “HACK” category? Yes! Translations Press Releases
62. PUBLISH • Sponsor Events • Donate to Non-Profit Orgs • Employ PG developers • Sponsor/Host PUGs @clairegiordano
63. Company Sponsorships help ecosystem to GROW
64. Q: Which 24 companies sponsored these 29 Postgres conferences at 10K € (total) or more? Total Sponsorships from these 24 companies: ~763,000 € @clairegiordano
65. Q: Which 13 companies employ the 30 Postgres committers? v17 timeframe, as of Aug/Sep 2024 Amit Langote * Andres Freund Daniel Gustafsson David Rowley Melanie Plageman Thomas Munro Tomas Vondra * 7 Jeff Davis Joe Conway Masahiko Sawada Michaël Paquier Nathan Bossart Peter Geoghegan 6 Álvaro Herrera Andrew Dunstan Bruce Momjian Peter Eisentraut Richard Guo * Robert Haas 6 EDB MICROSOFT AWS Etsuro Fujita Fujii Masao 2 NTT GROUP Tom Lane CRUNCHY DATA Amit Kapila FUJITSU Noah Misch GOOGLE Tatsuo Ishii SRA OSS LLC Heikki Linnakangas NEON Magnus Hagander REDPILL LINPRO John Naylor SELF Alexander Korotkov SUPABASE Dean Rasheed UNIV OF CAMBRIDGE
66. How to donate to these 3 Postgres Non-Profit Organizations (NPOs)? @clairegiordano PgEU PGCA postgres.ca/donate postgresql.us/donate postgresql.eu/donate
67. 67 PUBLISH • Boards of Directors • Code of Conduct • Core Team • Event Organizers • Event Talk Selection • Event Volunteers • Moderators • Teams/Committees • User Groups • Discord • IRC • Mailing Lists • Mentoring • Slack • Stack Overflow • Telegram • Books • Blog Posts • Conference Talks • Newsletters • Person of Week • Podcasts • Social Media posts • User Group Talks • Videos & Demos • Build Farms • Code Authors • Committers • Docs • Extensions • Packaging • Patch Review • Security Team • Test Infra • Translations • Web Team • Sponsor Events • Donate to Non-Profit Orgs • Employ PG developers • Sponsor/Host PUGs @clairegiordano
68. postgres- contrib.org New weekly effort to shine a light on Postgres contributions Founded July 2024 by: • Andreas Scherbaum • Boriss Mejías • Floor Drees • Jimmy Angelakos • Pavlo Golub
69. 69 WHY RECOGNIZE CONTRIBUTIONS?
70. Why recognize contributions? Feels good Incents behavior 1 2 @clairegiordano
71. Cannot reward what you don’t SEE… nor what you don’t MEASURE
72. 2 Ways to Discover Contribution (& reward it) Create Structure for people to input activities & contributions 1 Create Nomination Program e.g.“Postgres Stars” 2 Both of the above 3 @clairegiordano
73. One Idea: “Many Hats” award for Postgres @clairegiordano
74. Low Hanging Fruit 1) List Volunteers on Conference websites 2)Add Lightning Talk speakers & slide links to Schedules on Conference sites 3)Don’t delete past years of Conference websites!
75. Boriss Mejías Charles Feddersen Isaac Alves Krishnakumar Ravi Melanie Plageman My Nguyen Robert Haas Thomas Munro Tomas Vondra Daniel Gustafsson &… People to thank for inspiration &/or reviews
76. 76 Favors to ask you!
77. Our Talking Postgres podcast about human side of PG Recent guests: David Rowley, Melanie Plageman, & Tom Lane…
78. Save the date! aka.ms/posette-subscribe Subscribe to news  Brought to you by
79. on my Postgres work aka.ms/survey-pgconfeu-2024
80. To give PGConf EU survey feedback is a gift!
81. @clairegiordano @clairegiordano@hachyderm.io TalkingPostgres.com z aka.ms/posette z linkedin.com/in/claireg