Selena Deckelmann's blog

PostgreSQL 9.0: contributions!

posted on Sep 21, 2010
tags: code committers community contributions postgres
categories: postgres postgresql

New releases are opportunities for reflection!

As PostgreSQL grows, I would like to know how many people are contributing at any time. This is difficult to measure, given how many people contribute in ways not visible to the internet - advocating for PostgreSQL at work, sharing information about PostgreSQL offline in any way, or developing code related to PostgreSQL that isn't shared directly back.

PostgreSQL developers have a habit of mentioning the people involved in the development of features in the commit logs. This includes people who discuss topics on the mailing list, who report bugs, provide test cases or send in patches. I spent a bit of time digging through the commit logs and pulling out unique names that are mentioned. This is a lossy process, as the log files are long, names are not always easy to spot, and I only spent 6 hours going through it.

I've made it through the 9.0 (16163 lines of logs) and 8.4 logs (21257 lines of logs) so far.

Here's some basic information about them:

I'm working on graphs about number of lines inserted or deleted by each author, but need more time to work out the information presentation. Some interesting trends emerge about what the role of each committer is - particularly that there are a couple people who seem to be "gardeners" of the code - removing a lot of lines, sometimes more than they are adding. With a project as old as ours (first commit in 1996!), this maintenance work is critical.

I also did some grepping for key words in the commit messages:

wordtimes mentioned in 8.3times mentioned in 8.4times mentioned in 9.0
review241449
cute292625
tom lane904901635
gripe374826
hot standby0548
replication18452

You're welcome to explore our git repo at git.postgresql.org. Thanks to all the folks who worked on the git migration over the past few months, and finally made our transition from CVS to git complete last night!


Have some feedback? Corrections? Ideas for other posts? Contact me @selenamarie.