Wednesday, January 23, 2019

Who Contributed to PostgreSQL Development in 2018?

This is my third annual post on who contributes to PostgreSQL development.  I have been asked a few times to include information on who employs these contributors, but I have chosen not to do that, partly but not only because I couldn't really vouch for the accuracy of any such information, nor would I be able to make it complete.  The employers of several people who contributed prominently in 2018 are unknown to me.

I used the same methodology as in past years, with one slight change.  When I removed "large mechanical commits" from the line count for each author, I also removed all of the MERGE commits.  That's because MERGE was committed, reverted, committed again, and reverted again, and the number of lines of code involved was so large that it distorted the numbers very substantially.  It did not seem fair to include such a large impact from a patch that ultimately didn't stay in the tree in a measure of contribution.  I have not attempted to correct for other patches that were reverted, but I believe that the impacts are not nearly as serious.  I will post the raw data on my Google Site as well (robertmhaas) and others can do their own analysis if they wish.

According to my analysis, during 2018, 164 people contributed at least 1 new line of code to PostgreSQL.  32 of those contributors accounted for 90% of the lines of code committed, and 9 accounted for 66% of the lines of code committed.  In total, there were 2130 commits by 28 committers.  The work of committing patches written by someone other than the committer was principally shared by 4 committers who committed 66% of the lines of non-self-authored code; 8 committers accounted for 90% of the lines of non-self-authored code.

Here are the top 32 contributors by lines added to PostgreSQL in 2018.

 #  |        author         | lines | pct_lines | commits 
----+-----------------------+-------+-----------+---------
  1 | Tom Lane              | 58151 |     23.29 |     480
  2 | John Naylor           | 24318 |      9.74 |      22
  3 | Andres Freund         | 20581 |      8.24 |     113
  4 | Peter Eisentraut      | 17601 |      7.05 |     273
  5 | Amit Langote          | 12488 |      5.00 |      55
  6 | Emre Hasegeli         | 11713 |      4.69 |       8
  7 | David Rowley          |  8676 |      3.47 |      57
  8 | Alvaro Herrera        |  8156 |      3.27 |      96
  9 | Bruce Momjian         |  5958 |      2.39 |      74
 10 | Andrew Dunstan        |  5070 |      2.03 |      51
 11 | Peter Geoghegan       |  4403 |      1.76 |      29
 12 | Oliver Ford           |  4289 |      1.72 |       1
 13 | Michael Paquier       |  4256 |      1.70 |     111
 14 | Jeevan Chalke         |  3885 |      1.56 |      11
 15 | Etsuro Fujita         |  3190 |      1.28 |      25
 16 | Fabien Coelho         |  3127 |      1.25 |      17
 17 | Amit Khandekar        |  3025 |      1.21 |      11
 18 | Alexander Korotkov    |  2671 |      1.07 |      24
 19 | Shubham Barai         |  2651 |      1.06 |       3
 20 | Anastasia Lubennikova |  2345 |      0.94 |       2
 21 | Magnus Hagander       |  2252 |      0.90 |      20
 22 | Anthony Bykov         |  2118 |      0.85 |       2
 23 | Robert Haas           |  1951 |      0.78 |      32
 24 | Nikita Glukhov        |  1890 |      0.76 |       5
 25 | Thomas Munro          |  1634 |      0.65 |      69
 26 | Ashutosh Bapat        |  1441 |      0.58 |      20
 27 | Kyotaro Horiguchi     |  1423 |      0.57 |      20
 28 | Stephen Frost         |  1419 |      0.57 |      16
 29 | Fujii Masao           |  1416 |      0.57 |       2
 30 | Andrew Gierth         |  1349 |      0.54 |      19
 31 | David Steele          |  1176 |      0.47 |       7
 32 | Dean Rasheed          |  1171 |      0.47 |       3

Here are all of the committers who committed non-self-authored code.  Note that some of these people became committers only in the middle of the year.

 #  |     committer      | lines | pct_lines | commits 
----+--------------------+-------+-----------+---------
  1 | Tom Lane           | 39641 |     32.77 |     168
  2 | Alvaro Herrera     | 16703 |     13.81 |      97
  3 | Teodor Sigaev      | 13646 |     11.28 |      44
  4 | Tomas Vondra       | 11998 |      9.92 |       8
  5 | Robert Haas        | 11897 |      9.83 |      70
  6 | Peter Eisentraut   |  7561 |      6.25 |      60
  7 | Andres Freund      |  4387 |      3.63 |      48
  8 | Michael Paquier    |  4273 |      3.53 |      88
  9 | Alexander Korotkov |  2345 |      1.94 |      15
 10 | Stephen Frost      |  1180 |      0.98 |       9
 11 | Andrew Dunstan     |  1073 |      0.89 |       7
 12 | Simon Riggs        |  1008 |      0.83 |      17
 13 | Thomas Munro       |   995 |      0.82 |      11
 14 | Heikki Linnakangas |   983 |      0.81 |      16
 15 | Magnus Hagander    |   717 |      0.59 |      31
 16 | Michael Meskes     |   536 |      0.44 |       6
 17 | Jeff Davis         |   383 |      0.32 |       2
 18 | Tatsuo Ishii       |   309 |      0.26 |       3
 19 | Amit Kapila        |   300 |      0.25 |      10
 20 | Fujii Masao        |   282 |      0.23 |       6
 21 | Bruce Momjian      |   255 |      0.21 |      22
 22 | Andrew Gierth      |   206 |      0.17 |       3
 23 | Dean Rasheed       |   156 |      0.13 |       1
 24 | Joe Conway         |   139 |      0.11 |       1
 25 | Peter Geoghegan    |     4 |      0.00 |       1

And here, thanks again to Stephen Frost, is a list of everyone who wrote at least 100 emails to pgsql-hackers last year; this covers about 77% of the total posts.

             name              | sum
-------------------------------+------
 Tom Lane                      | 2699
 Michael Paquier               | 1868
 Andres Freund                 | 1799
 Robert Haas                   | 1179
 Alvaro Herrera                | 1128
 Peter Eisentraut              |  842
 Amit Langote                  |  777
 Thomas Munro                  |  696
 David Rowley                  |  670
 Tomas Vondra                  |  598
 Peter Geoghegan               |  498
 Pavel Stehule                 |  479
 Stephen Frost                 |  478
 Amit Kapila                   |  440
 Kyotaro Horiguchi             |  399
 Andrew Dunstan                |  398
 Fabien Coelho                 |  377
 Bruce Momjian                 |  354
 Alexander Korotkov            |  301
 Ashutosh Bapat                |  287
 Andrew Gierth                 |  274
 Masahiko Sawada               |  264
 David Steele                  |  244
 Simon Riggs                   |  242
 Etsuro Fujita                 |  238
 Magnus Hagander               |  228
 Dmitry Dolgov                 |  226
 Konstantin Knizhnik           |  223
 Craig Ringer                  |  194
 Heikki Linnakangas            |  193
 Daniel Gustafsson             |  177
 Andrey Borodin                |  159
 David Fetter                  |  159
 John Naylor                   |  156
 Fedor Sigaev                  |  152
 Takayuki Tsunakawa            |  147
 David Johnston                |  138
 Haribabu Kommi                |  134
 Chapman Flack                 |  132
 Tatsuo Ishii                  |  127
 Jonathan Katz                 |  122
 Arthur Zakirov                |  111
 Pavan Deolasee                |  111
 Justin Pryzby                 |  109
 Sergei Kornilov               |  106

Thanks to all who contributed, and best wishes to everyone for an awesome 2019, both for PostgreSQL and for everyone individually.

No comments:

Post a Comment