Nazir Bilal Yavuz



Reading time: 5 minutes

Tags:   postgresql (208)   microsoft (10)   opensource (27)   community (30)   hackers (6)  
Category:   interviews   
Interview conducted by: Andreas Scherbaum

PostgreSQL is the World’s most advanced Open Source Relational Database. The interview series “PostgreSQL Person of the Week” presents the people who make the project what it is today. Read all interviews here.

Please tell us about yourself, your hobbies and where you are from.

I am Nazir Bilal Yavuz, open source PostgreSQL developer working at Microsoft. I live in Turkey. I spend my free time by doing sports, playing games and football, watching tv series and movies.

Nazir Bilal Yavuz
Nazir Bilal Yavuz

Any Social Media channels of yours we should be aware of?

Last book you read? Or a book you want to recommend to readers?

I read ‘The Wise Man’s Fear’, the second book of the ‘The Kingkiller Chronicle’ series. I would like to recommend it but please keep in mind that the third book of the series has been long awaited.

When did you start using PostgreSQL, and why?

I started really using PostgreSQL when I joined the ‘Open Source PostgreSQL team’ at Microsoft. Before that, my experience with Postgres was limited with the classes I took in university.

Do you remember which version of PostgreSQL you started with?

I started with PostgreSQL 14.*.

Yes, I have a bachelor of science in computer engineering. Yes again, especially ‘introduction to operating systems’ and ‘data management and file structures’ courses really helped to understand how PostgreSQL works.

I am currently helping on implementing streaming IO & vectored IO in PostgreSQL. It is basically about trying to create bigger read calls to the kernel (It is currently limited to one block (8 KB as default)). Also, it looks for which block you will read next and prefetch.

The thread of streaming IO & vectored IO.

The thread of using streaming IO & vectored IO while running ANALYZE.

In addition to that, I am working on adding WAL stats to pg_stat_io view but it is on hold because there are some ongoing patches that can affect the implementation of this patch.

Thread of adding WAL stats to pg_stat_io view.

How do you contribute to PostgreSQL?

I contribute to PostgreSQL by sending and reviewing patches. I am following -hackers mailing list and joining the discussions there. Also, I am trying to review at least one patch in each commitfest.

Any contributions to PostgreSQL which do not involve writing code?

I am not sure if this counts but I gave a talk about some tips about using PostgreSQL’s CI more efficiently.

What is your favorite PostgreSQL extension?

In-core: pg_stat_statements. I find it very useful because it provides valuable insights into query performance, resource usage and overall database health.

Outside the core: Citus. I am biased but making PostgreSQL distributed is a very nice idea.

What is the feature you like most in the latest PostgreSQL version?

I like the meson build system. It makes building and testing faster, also it is easy to read and understand.

Adding to that, what feature/mechanism would you like to see in PostgreSQL? And why?

I would like to see streaming IO & vectored IO as I mentioned before. It increases PostgreSQL’s IO throughput without increasing the number of IOs since it can create bigger reads.

Could you describe your PostgreSQL development toolbox?

I use Debian and Windows most of the time. I use Visual Studio Code to code and as an IDE. I choose building PostgreSQL with meson rather than autoconf as I find meson builds more user friendly.

Which skills are a must have for a PostgreSQL developer/user?

I think familiarity with the C programming language and using command line tools are the most useful skills. In addition to that, having experience with Perl is helpful since the source code includes a lot of Perl code.

Do you use any git best practices, which makes working with PostgreSQL easier?

Creating patches with:

git format-patch HEAD~N -vJ

where N is the how many commits the patchset will include and J is the version number.

Also, while working on couple of commits and when you need to push changes to previous commits (not the last one), you can use:

git add {files}
git commit --fixup=${1}
git rebase --interactive --autosquash ${1}^

where ${1} is the hash number of commits that you want to add to.

Do you think PostgreSQL has a high entry barrier?

I am answering that as a developer. It does not have a high entry barrier but I think it can be hard to get used to for the current generation of developers. Communication on mailing lists and sending patches instead of PRs are not very common anymore.

What is your advice for people who want to start PostgreSQL developing - as in, contributing to the project. Where and how should they start?

They can start by subscribing to -hackers and -bugs mailing lists. These mailing lists are where most of the discussion happens. They can look through the commitfest app, then work on and review patches there.

Are you reading the -hackers mailing list? Any other list?

Yes, I often check -hackers and -bugs mailing lists.

What other places do you hang out?

I am on the Microsoft open source discord channel.

Which other Open Source projects are you involved or interested in?

I do not have any for now but I’m hoping to get more involved in other open source projects soon.

Anything else you like to add?

I am thankful to the people who helped me contribute to PostgreSQL.


Share: