Well, that sounds exciting, but I am a novice programmer from data science field. So, I am more like a user, rather than a developer.
Contributing to world class projects such as Postgres sounds cool, but doesn't it take years of experience?
Of course there are other benefit of learning C as you noted.