Introduction:

I am Rahila Syed. I have worked on developing features for PostgreSQL and its extensions for 12 years, the last few of which have been focused on a PostgreSQL extension called PGD, which provides a multi-master, geo-replicated database using logical replication.

Journey in PostgreSQL:

I started working on PostgreSQL straight out of college after finishing my Bachelor’s degree in IT Engineering. NTT DATA’s OSS division hired a group of fresh graduates to work on PostgreSQL, and I was one of them. Working with a team of recent graduates was a fun experience. We were introduced to PostgreSQL architecture by mentors at NTT DATA and began our hacking journey.

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

A memorable moment was when I had the opportunity to attend PGCon, the oldest and most reputable PostgreSQL developer conference, in Ottawa and present my work on WAL reduction.

Contributions and Achievements:

I have contributed to features like FPW compression in WAL, parallel index scan, column filtering in logical replication among others.

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

I have faced numerous challenges, from the first draft of a patch all the way to getting it committed. Asking for help from smarter, more experienced folks sooner rather than later has helped me overcome these challenges.

Community Involvement:

By participating in mailing lists like pgsql-hackers and postgres conferences.

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

I have had the opportunity to interact with some amazing women coders in my career and have learnt a great deal from them. I am looking forward to fostering more such relationships in the future.

Insights and Advice:

All the best, and have faith in your abilities!

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

I personally rely heavily on the official PostgreSQL documentation and code comments to understand the functioning of PostgreSQL. Additionally, I listen to talks given by developers at various conferences to enhance my understanding of different topics.

Looking Forward:

Project to move postgres from a multi-process to a multi-threaded architecture.

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

I look forward to contributing more to open source PostgreSQL development in my new role, which I will begin this month.

Personal Reflection:

It gives me the opportunity to learn by interacting daily with the talented engineers behind this great database.

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

I think it is a constant struggle, but having a support system both at home and within the team helps a lot. It is also beneficial to voice your concerns whenever necessary.

Message to the Community:

Kudos to you and your contributions!