Introduction:

Hello, I’m Alicja Kucharczyk, a dedicated PostgreSQL professional with 12 years of experience, starting from version 9.0. Throughout my career, I’ve immersed myself in various roles within the PostgreSQL ecosystem, including developer, DBA, consultant, and trainer. Currently, I serve as a Principal Program Manager at Microsoft, focusing on our cloud-based PostgreSQL PaaS offering, Flexible Server.

As an avid PostgreSQL advocate, I’ve delivered nearly 100 talks worldwide and founded the Warsaw PostgreSQL Users Group. I’m also proud to have produced the first and second-ever PostgreSQL songs.

Journey in PostgreSQL:

My journey with PostgreSQL started in a pretty unexpected way. I had applied for a PHP developer role at a Polish bank, but when I showed up for work, they assigned me to be a database specialist instead. To my surprise, the database they were using was PostgreSQL, which I had only heard of but never used before. And that’s how my adventure with PostgreSQL began!

(II) Can you share a pivotal moment or project in your PostgreSQL career that has been particularly meaningful to you?

It’s not easy to pick just one moment, but a particularly meaningful one was when I transitioned into a consultant role. This experience was eye-opening because I discovered that regardless of the company’s size or industry, the issues people face with PostgreSQL are remarkably similar. It was both challenging and rewarding to help various organizations solve their PostgreSQL problems and optimize their databases.

Contributions and Achievements:

I’m particularly proud of the PostgreSQL songs I’ve produced. The first one, “Nothing Compares To VACUUM/The Ballad of Bloat,” tells the story of a sad DBA who lost her permission to run VACUUM and the pain of growing bloat. The second song is a cheerful tune about EXPLAIN ANALYZE.

(II) Have you faced any challenges in your work with PostgreSQL, and how did you overcome them?

I’ve definitely faced my share of challenges working with PostgreSQL. One big issue is the lack of standardization in monitoring. When I start consulting for a new customer, the first thing I often have to do is ask them to set up proper monitoring tools. Without proper data, it’s really hard to diagnose and solve PostgreSQL problems, whether they’re related to performance or other issues.

Another challenge is the misconceptions people have about PostgreSQL. The documentation is fantastic, but it’s not always the best starting point for beginners. Plus, a lot of external sources aren’t very reliable, which leads to myths and misunderstandings. To tackle this, I always stress the importance of proper monitoring right from the start and help guide newcomers towards trustworthy resources and best practices.

Community Involvement:

I participate in conferences, sometimes as a speaker, sometimes just as an attendee, and sometimes as part of the talk selection committees. I also run the Polish PostgreSQL meetup group, which I need to revive after a bit of a break. It’s always exciting to connect with others in the community, share knowledge, and learn from each other.

(II) Can you share your experience with mentoring or supporting other women in the PostgreSQL ecosystem?

One thing I’ve noticed is that women often feel less confident about their skills and knowledge, and they might need a bit more encouragement to submit a talk or even attend a conference. I really admire the Postgres Women India initiative, and I hope that with support from all of you, more women will feel empowered to join the PostgreSQL community. I’ve tried to support and mentor women by encouraging them to take those first steps, whether it’s speaking at an event or simply participating more actively in the community. It’s important to create an environment where everyone feels welcome and valued.

Insights and Advice:

My advice to women starting their careers in technology, especially in database management and PostgreSQL, is not to be afraid or discouraged when things go wrong or when you don’t know something (yet). PostgreSQL is definitely a technology you can bet on—it’s growing rapidly, and investing your time in learning is a safe choice. Even after 12 years of working with PostgreSQL, there are still areas I’m not especially good at, and I’ve had my own misconceptions along the way. It’s completely normal; it’s just part of the learning curve. So, be patient with yourself, keep learning, and remember that everyone starts somewhere.

(II) Are there any resources (books, courses, forums) you’d recommend to someone looking to deepen their PostgreSQL knowledge?

Absolutely! My first go-to resource when I’m checking things is the PostgreSQL documentation, which is incredibly thorough. I also find the mailing list extremely useful. A tip for searching the mailing list is to use Google with the phrase you’re interested in and specify the mailing list like this: “your term” site:postgresql.org/message-id.

I’m also a big fan of Cybertec’s blog. They have a great way of explaining complex topics in a really simple and understandable manner. You can check out their blog here: https://www.cybertec-postgresql.com/en/blog/.

Although it’s a bit old and the title suggests it’s about older versions, my favorite PostgreSQL book is “PostgreSQL 10 High Performance.” It has a lot of valuable information that’s still applicable to newer versions of PostgreSQL, even if it seems a bit outdated.

Looking Forward:

I’m really excited about the advancements in logical replication. Even though it’s been around since version 10, more and more people are starting to use it now. The use cases are so broad—not just for CDC (Change Data Capture) solutions in modern architectures, but also for migrations, near-zero downtime upgrades, blue/green deployments, and many more. It’s amazing to see how logical replication is opening up new possibilities and making various types of integrations easier.

(II) Do you have any upcoming projects or goals within the PostgreSQL community that you can share?

Yes, I do! I’m working on a new PostgreSQL song 🙂 Stay tuned!

Personal Reflection:

Being part of the PostgreSQL community means a lot to me. It’s more than just a professional network; it’s a supportive and collaborative group of people who are passionate about open-source technology. The community has been a source of inspiration, learning, and friendship for me over the years. It’s truly rewarding to contribute to such a dynamic and inclusive environment.

(II) How do you balance your professional and personal life, especially in a field that is constantly evolving?

Honestly, balancing my professional and personal life is something I’m still working on and definitely need to improve. I’m learning to set boundaries and make more time for myself, but it’s a work in progress. I think it’s important to recognize that it’s okay to take a step back and recharge.

Message to the Community:

Don’t be afraid to take that leap. Your skills and perspectives are incredibly valuable. It’s normal to feel uncertain or face challenges, but remember, everyone starts somewhere. The PostgreSQL community is welcoming and supportive, and there are many resources and people ready to help you along the way. Keep learning, stay curious, and don’t hesitate to share your ideas and experiences. We need more diverse voices to continue driving innovation and growth. You’ve got this!