1) Let’s start with you! Tell us a bit about yourself – your background, current role, and what excites you most in the world of tech.

I’m Lakshmi Sravya, a software engineer currently working at JPMorgan Chase. I’m deeply fascinated by the intersection of AI and databases, and I spend my time exploring how generative AI can optimize PostgreSQL queries and performance. I enjoy diving into PostgreSQL’s internals, experimenting with features like logical replication and foreign data wrappers (FDW), and solving complex problems that push the boundaries of database performance and reliability. What excites me most is building smarter, more efficient systems that combine AI’s intelligence with PostgreSQL’s powerful data processing capabilities.

2) Why PostgreSQL? What inspired you to explore or switch to PostgreSQL?

My PostgreSQL journey began at Amazon, where I first encountered it. The depth and flexibility of PostgreSQL fascinated me, and I was fortunate to have mentors and subject matter experts who patiently guided me through both the basics and advanced concepts. This solid foundation sparked my passion for PostgreSQL and its ecosystem.

3) What are you working on with PostgreSQL right now? Share the cool stuff you’re building, learning, or solving using PostgreSQL.

Currently, I am working on an open-source project focused on optimizing database queries using generative AI techniques. This is one of the most interesting problems in database engineering today-finding ways to embed the power of AI with PostgreSQL’s robust query processing to enhance performance and efficiency. Alongside this, I continue to explore and implement PostgreSQL features to solve complex data challenges.

4) What’s been your biggest learning or challenge on this journey?

A lesson, mistake, or an aha moment, we’d love to hear about it!

One of my proudest moments was when I helped my husband with his GeoDjango project, which had millions of records but suffered from high query latency. I introduced pg_partman to partition his huge database, drastically improving performance. That moment, along with many others where I helped clients solve critical, almost doomsday-level problems, reinforced my confidence in PostgreSQL’s power and my skills.

5) Your wisdom to rookies like yourself?

What’s one tip or piece of advice you’d give to someone just starting out with PostgreSQL?

Focus on mastering the fundamentals of SQL and relational databases first. Don’t hesitate to ask questions and learn from the community and mentors, they were invaluable to me. Explore PostgreSQL’s unique features like logical replication and foreign data wrappers (FDW), and use tools like EXPLAIN to understand query performance. Be patient with complex concepts like MVCC; once you understand it deeply, everything becomes much easier.

6) Finally, describe your PostgreSQL journey in one word.

Yep, just one!

Empowering- has given me the confidence, tools, and community support to tackle complex challenges and build impactful solutions.

7) Who or what has influenced your PostgreSQL learning the most?

A mentor, a community, a course, a project, tell us what or who helped you grow.

Recently, I participated in the Postgres Women India Upskill Program, where I had the opportunity to learn from many PostgreSQL experts. One person who has become my go-to mentor is Hari Sir, whose guidance and support have been instrumental in my growth. Along with the mentors I met at Amazon and the vibrant PostgreSQL community, these influences have greatly shaped my journey.

8) What’s one PostgreSQL concept or feature you finally understood and felt proud of?

That lightbulb moment when something clicked, we all have one!

The logical replication feature stands out for me. Understanding how PostgreSQL’s publish-subscribe model works to replicate data incrementally and in real-time was a game changer. I also admire FDW for its ability to connect and query across different data sources seamlessly. On the challenging side, MVCC was tough to grasp initially, but once I understood its inner workings, it unlocked a much deeper appreciation for PostgreSQL’s concurrency and transaction management.