#PostgresFriends

Michael Paquier

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 from France, based in Japan. In my spare time, I happen to read a lot of books to focus on something other than work.

Michael Paquier (photo by Oleg Bartunov)

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

When did you start using PostgreSQL, and why?

I started working on PostgreSQL in 2009, sending some patches to the community, and got involved from 2009 to 2012 in Postgres-XC, a fork of Postgres, shared-nothing clustering solution good for OLTP workloads. Since 2013, I have focused my attention entirely to core Postgres.

Do you remember which version of PostgreSQL you started with?

8.3.

Have you studied at a university? If yes, was it related to computers? Did your study help you with your current job?

Fluid dynamics, specialized in simulations, at an engineering school called ENSEEIHT in France, where they have several departments including one for IT engineering. This has opened me doors to be able to live in the country where I am now, though I am working on a completely different field (laugh).

What other databases are you using? Which one is your favorite?

Pass. I guess you know the answer.

On which PostgreSQL-related projects are you currently working?

I maintain a couple of extensions on github, like https://github.com/michaelpq/pg_plugins/, and I got to work on the integration of PostgreSQL in products for my current company (HA, backup/restore, upgrades, performance, etc.)

How do you contribute to PostgreSQL?

Hacker, blogger, patch reviewer, patch author and sometimes committer, trying mainly to not anger the community buildfarm. I think that I may have contributed more than 1000 patches to Postgres, from tiny to bigger things, in various areas of the code base. But I don’t really keep track of all that.

Any contributions to PostgreSQL which do not involve writing code?

My blog, and contributions in my company to push more people to contribute to upstream.

Which PostgreSQL conferences do you visit? Do you submit talks?

Mainly PGcon in Ottawa, few Asian conferences unfortunately. I have been to PGConf Europe and PgConf Russia in the past, and the attendance is very passionate. I try to submit talks when I have interesting topics or things I want to talk about..

Do you think Postgres has a high entry barrier?

Postgres is very old-school when it comes to hacking, with interactions using mailing lists and no actual bug trackers. Newcomers, youngsters or people fan of hyped technologies don’t like that much, making the entrance barrier much harder.

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

Don’t refer to the TODO items in the wiki. Client binaries and extensions always have stuff which can be done, the barrier is lower than the backend.