Interview with Adyen
Any views or opinions represented or expressed in this interview belong solely to the interviewee and do not necessarily represent those of the PGConf.EU 2023 organization, PostgreSQL Europe, or the wider PostgreSQL community, unless explicitly stated.
- What makes your company a great place to work?
We work with PostgreSQL on a level with very high volume and load! Because of this, we often run into some very interesting, and still unknown problems, providing us with really unique challenges. We often look into some special corner cases, and occasionally this requires us to analyse the behaviour of PostgreSQL on various hardware and OS environments. With our growth, we are always looking at opportunities to scale and automate.
Our team members have trust, and are enabled to do their job at their best; coming up with their own solution, while having the possibility of sparring with other knowledgeable DBAs and other talented technicians. We have an environment where people can both learn and utilise their knowledge at their best. We are also part of a diverse and global team, and we have a really good company culture.
Asking our DBAs, why they like to work here: "Because I can work on interesting complex projects surrounded by very smart and fun people, drive my own career path, contribute to the company growth and have fun. All at the same time!" "The collaborative atmosphere!" "There is not a single boring day!"
- Which of your company's contributions to the PostgreSQL Project (code/community/conference) are you most proud of?
In general, whenever we run into some interesting challenges of PostgreSQL, we like to dive into the problem, solve it, and then share our insights and learnings with the community. Some of our recent blogs:
- Injecting metadata as comments in our SQL queries: an “interesting” story
- A Deep Dive into Table Partitioning
- PostgreSQL and HOT updates
For the above topics, we have also presented at various events, such as PgConf 2022, PGDay Chicago 2023, FOSDEM and PGDay EU 2023, Nordic PGDay 2023, to name a few. We have also hosted two PgConf Meetups in Amsterdam at our HQ office this year.
- Which feature is missing in PostgreSQL?
There are a few features we would love to have implemented in PostgreSQL: Ability of dropping indexes concurrently on a partitioned table. Getting the current explain state of a currently executing long query. A proper global index.