Peter Zaitsev



Reading time: 11 minutes

Tags:   postgresql (208)   opensource (27)   performance (11)   entrepreneurs (2)   percona (3)   geeksgopeaks (1)  
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, and where you are from.

I was born and raised in Moscow, Russia, graduated from Moscow State University and had my first startup there. In 2004 I moved to the US while working at MySQL AB.

Peter Zaitsev
Peter Zaitsev

How do you spend your free time? What are your hobbies?

I like “Adventure Networking” spending time outdoors. Running, Climbing, Obstacle Course racing… I’ve been formalizing some of those as GeeksGoPeaks project encouraging more Geeks to embrace adventures and outdoors

Any exercises you do regularly?

I run 6 days a week - 70 km or so, and also do group fitness HIIT style 2-3 times a week when I’m in town.

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

peterzaitsev.com is a good “Hub” for all things Peter Zaitsev.

Are you known by a nickname in the community? If yes, what’s the history?

I can go by PeterZ or even PZ just because “Peter Zaitsev” have been hard to pronounce to some.

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

As you can see from the list I’ve been more on the business/entrepreneurship side when it comes to books - from technology side I find other sources provide more real time technical information

If you look at technology specific books - Systems Performance is awesome.

I think it is a waste of time to read „trivia books“ which tell you what specific commands you should use in this given PostgreSQL version. This is even more so in the age of AI. What is more important is understanding principles of systems design and performance analyses and from this standpoint the database is just another system. If you have systematic architecture of systems architecture and performance optimization fundamentals you can apply them to any system.

Favorite movie, or show?

There are so many. “Black Mirror” in particular earlier seasons was very thought provoking.

Best music, best song?

I do not have a particular song - it is all mood and purpose related. Classic Rock is one of the styles I love.

Best food?

Sushi ? I love a variety of things and appreciate unusual foods - if you have some dried crickets to snack on I’d love to.

Best drink? Non-alcoholic or alcoholic?

Ayran (yogurt based drink) or Kombucha, also love all kinds of teas.

What does your ideal weekend look like?

As a happily married man… Do we need to keep it PG here 🙂 A good weekend is an active weekend - doing some fun races, going outdoors for rock climbing or hiking and ending up with some good food and a movie.

What’s still on your bucket list?

Oh… there are so many places to explore and things to do and I have new ideas almost every month. I want to visit Antarctica one day, perhaps climb a mountain on that day. Also Matterhorn one day would be fun

What is the best advice you ever got?

Treat people as they want to be treated, rather than like you want to be treated. It took me a while to recognize not everyone approaches life, thoughts, and is motivated in the same way I am.

When did you start using PostgreSQL, and why?

I almost started using PostgreSQL back in 1999 for my first startup (SpyLOG), but a chance encounter with MySQL, made me use it instead.

I really followed PostgreSQL for years but it was only in 2018 when Percona officially started supporting PostgreSQL. One of our key principles at Percona is to be on the customer side - help them with choices when they ask us, and help them to be most successful with choices they made. PostgreSQL appeared as something our customers needed and wanted years before, but as a Bootstrapped company we needed to make sure we have resources to do it well, and be in position to help our customers with most complicated situations they are facing, so it was not until 2018 we got to it.

Do you remember which version of PostgreSQL you started with?

At Percona we started with PostgreSQL 11, but I also was randomly involved with earlier versions for a while.

I studied Computer Science at Moscow State University. I think it was quite helpful for my career, in particular understanding fundamentals - things like probability and statistics, discrete math, game theory etc have a lot of application if you really want to understand how databases operate.

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

MySQL is the database I’m the most comfortable with. In recent years I got fascinated with technologies like SQLite, Prometheus, Clickhouse and DuckDB.

In Percona we’re working on Open Source Transparent Database Encryption TDE and making AWS RDS like experience for PostgreSQL in other databases in Percona Everest. We also have some very cool support for PostgreSQL observability in Coroot.

How did Percona start using PostgreSQL?

At Percona we’re not for picking sides but rather meeting customers where they are. As more and more customers started to run PostgreSQL we started to support it alongside with MySQL

Money question: will Percona grow more with MySQL or PostgreSQL?

A larger part of our business still comes from MySQL but PostgreSQL business is growing more rapidly.

How do you contribute to PostgreSQL?

Percona is contributing to PostgreSQL through extensions and also to the PostgreSQL ecosystem - we have an Operator to run PostgreSQL on Kubernetes, PostgreSQL Monitoring in PMM (Percona Monitoring and Management), and PostgreSQL support in some tools in Percona Toolkit.

Any contributions to PostgreSQL which do not involve writing code?

Yes. We’ve been supporting a lot of PostgreSQL events Percona and I personally have been helping to evangelize PostgreSQL a lot. For example, I recently keynoted at the PostgreSQL India conference.

What is your favorite PostgreSQL extension?

It is hard to pick a favorite as there should be the right tool for the right job. If I have to pick one I would pick pg_stat_statements - I’m imperial to understanding query performance. We also used it as a base for pg_stat_monitor - more advanced solution for query performance monitoring.

What is the most annoying PostgreSQL thing you can think of? And any chance to fix it?

Technical: Replication of DDLs to name one. There are a number of external solutions for it but not a built-in one.

Organizational: I find it puzzling there is no bugs database similar to bugs.mysql.com - Relaying on mailing list for bug tracking is puzzling.

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

I love Async IO coming in the PostgreSQL 18

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

Some form of Sharding solution. ScalingUP can only get you so far and it becomes painful and expensive on the top end.

Should PostgreSQL have a built-in connection pooler?

Connection point is a technique… one way or another it is easier for users if PostgreSQL by itself is efficient at handling many concurrent connections and many connections per second.

Requiring extra components for what you can see as a simple core feature is not great.

Should PostgreSQL have built-in multi-master replication?

Yep. I know some folks do not think Multi-Master replication is a good pattern, yet some folks find it very useful. In general simpler (to use) replication/clustering requiring less components is appreciated.

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

Lets face it, Users increasingly can use tools like AI based „vibe coding“ to build PostgreSQL backed applications with virtually no skills, and this will continue.

If you really want to build and operate complex PostgreSQL based applications at Scale I think you need to have both a great understanding of computer systems, including networking, storage cloud, as well as database internals and SQL fundamentals like relational algebra.

As the time goes though, I would expect the fraction of experts possessing this broad internal knowledge will continue to go down.

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

I visit a variety of pgconf/pgday events as well as PostgreSQL tracks which exist at many events these days. Last two conferences I’ve been to were in Orlando and Bangalore, India.

We also have PostgreSQL coverage on Percona organized events such as Percona Connect and Percona University. I do submit talks, mainly higher level as I’m not as great hands-on PostgreSQL expert.

Do you think PostgreSQL has a high entry barrier?

It depends on what you mean by PostgreSQL. You can see an increasing number of developers using PostgreSQL as part of their hosted development framework like Vercel - it is made to be very easy. There are also solutions like Supabase which are also optimized for developer simplicity. When there are DBaaS solutions such as Amazon RDS PostgreSQL which also can be provisioned with 2 clicks and easy to manage, it is also rather easy.

However if you’re doing a proper „do it yourself“ Open Source PostgreSQL set up as a high performance secure highly available cluster it is not very easy. I love the work which is done with Kubernetes Operators to simplify this. We’re also working in Percona Everest Project to lower the entry barrier in fully open source self hosted environment

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

I think the most important advice is to pick what you’re passionate about and work in this field - the PostgreSQL ecosystem is huge and you can work on PostgreSQL Core, extensions or a variety of GUI tools and clients.

Do you think PostgreSQL will be here for many years in the future?

Yes. First databases are incredibly sticky, second - PostgreSQL right now has great momentum and is only gaining market share.

Would you recommend PostgreSQL for business, or for side projects?

PostgreSQL has become the default choice for many projects - large and small and I think for a good reason. Having said that, while PostgreSQL is great for many use cases, it is not the perfect solution for everything. Nothing is.

What is your opinion on ORMs?

ORMs are a reality. Also there are a lot of developers who can’t really use databases directly without ORMs, whether I like it or not. My main advice re ORMs is - as developer it is your opportunity what queries you generate, whenever it is with help of ORM or not. So if the ORM produces suboptimal queries it is your responsibility to fix it - whenever configuring ORM or bypassing it all together for this particular query. A lot of problems with ORMs come from developers taking the opposite approach - “this is the query my ORM generates, make PostgreSQL handle it…” it does not work!

SQL versus NoSQL databases?

SQL is not the only language and Relational is not the only data model, yet they do fit very well for a lot of use cases. I like people spelling out NoSQL as Not-Only-SQL which I think is where a lot of things are moving to. Databases like PostgreSQL can be accessed through a variety of different protocols, for example PostgreSQL can act like MongoDB with the help of FerretDB. On the other hand many non relational databases tend to provide something like an SQL language - CQL or N1QL being examples.

What other places do you hang out?

I’m most active on LinkedIn.

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

The Open Source ecosystem in general fascinates me, with a focus on Infrastructure related projects. I can get involved as an advisor or investor and help to spread the world.

Besides Percona with its variety of Open Source projects I’m involved in FerretDB and Coroot. I also love Clickhouse and VictoriaMetrics - both have such awesome teams focused on pushing the boundaries of performance.

Anything else you like to add?

I would invite outdoor/adventure focused leaders to check out the GeeksGoPeaks project. It would be fun to go have adventures with more people from the PostgreSQL or wider database community. In fact it was Oleg Bartunov of PostgreSQL fame who inspired me to organize this project by inviting me to go trekking with him in Pakistan a few years ago.


Share: