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 Nisha, a software developer at Fujitsu, working deep in the internals of PostgreSQL. I spend my time writing C, breaking things, fixing them, and contributing patches and features to the core—sometimes reviewing others’ work too. What excites me most is building smarter, more resilient distributed systems—especially when it comes to replication, consistency, and conflict resolution.
2) Why PostgreSQL?
What inspired you to explore or switch to PostgreSQL?
I started with PostgreSQL when I joined Fujitsu about one and a half years ago. Once I started working on it, I got pulled in by how powerful and elegant it is under the hood. The more I explored its internals—especially replication—the more it fascinated me. It’s not just a database, it’s an entire world of design choices, performance challenges, and open-source brilliance.
3) What are you working on with PostgreSQL right now?
Share the cool stuff you’re building, learning, or solving using PostgreSQL.
Currently, I’m working on conflict detection and resolution for logical replication. I recently developed a solution for detecting multiple_unique_conflicts, which has been committed to PostgreSQL 18. I was also involved in introducing another PostgreSQL 18 feature that automatically invalidates replication slots based on activity timeout.
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 biggest challenges was getting comfortable with the PostgreSQL codebase—it’s vast and layered, and at first, I often felt lost. Every time I thought I understood how something worked, an edge case would show up and flip that understanding. But over time, I learned to navigate the system with more confidence. Those “wait, that’s how it works?!” moments turned out to be the most rewarding part of the journey.
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?
Start by using PostgreSQL, then slowly lift the hood. Follow the -hackers mailing list and pick one subsystem—like the optimizer or replication—to explore in depth. Don’t hesitate to ask questions, report bugs, or even propose fixes and features. The PostgreSQL community is more welcoming than you might expect.
6) Finally, describe your PostgreSQL journey in one word. Yep, just one!
Transformative – It’s reshaped how I think and build systems.
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.
Definitely the people around me. My whole team at Fujitsu is incredibly talented, and I learn something new from them every single day. Special mention to Amit Kapila, Vigneshwaran C, and Shveta Malik—their depth of knowledge and willingness to share it has shaped a big part of my PostgreSQL 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!
Replication slots. At first, they felt like dark magic—but once I understood the underlying concepts and how they preserve WALs to ensure subscriber consistency, everything clicked. Eventually, I got to work on features to make them even more robust, which made the journey feel full circle.
Our idea explores the implementation of AI-driven query optimization in PostgreSQL, addressing the limitations of traditional optimization methods in handling modern database complexities. We present an innovative approach using reinforcement learning for automated index selection and query plan optimization. Our system leverages PostgreSQL’s pg_stat_statements for collecting query metrics and employs HypoPG for index simulation, while a neural network model learns optimal indexing strategies from historical query patterns. Through comprehensive testing on various workload scenarios, we will validate the model’s ability to adapt to dynamic query patterns and complex analytical workloads. The research also examines the scalability challenges and practical considerations of implementing AI optimization in production environments.
Our findings establish a foundation for future developments in self-tuning databases while offering immediate practical benefits for PostgreSQL deployments. This work contributes to the broader evolution of database management systems, highlighting the potential of AI in creating more efficient and adaptive query optimization solutions.
This talk provides an introductory overview of Artificial Intelligence (AI) and Machine Learning (ML), exploring key concepts and their application in building intelligent systems. It will highlight the essential AI/ML techniques, such as supervised and unsupervised learning, and discuss practical use cases in modern industries. The session also focuses on how PostgreSQL, with its powerful extensions like PostgresML, TimescaleDB, and PostGIS, supports the development of AI-powered applications. By leveraging PostgreSQL’s ability to handle complex datasets and integrate machine learning models, participants will learn how to build scalable, intelligent solutions directly within the database environment.
Success is a multiplier of Action, External Factors and Destiny.
Out of these three, the only controllable aspect is our action. Again, action is the result of our EQ, IQ, SQ, and WQ (Willingness Quotient) together.
We all want to be successful and keep trying to motivate ourselves with external factors. We read inspirational books, listen to great personalities, and whenever possible upgrade ourselves with more knowledge and the list goes on.
Indeed these are excellent motivators, but in this process, we forget the most important source of energy, YOU!
We read other stories to feel inspired, thinking “I am not enough!”
But, the day we start accepting ourselves, introspect, understand, and align our life purpose with our routine, we find the internal POWER. This is a continuous source of motivation and energy which we need at down moments. When we feel, lonely, stuck and seek help, our inner voice is the greatest companion.
But, how many times do we consciously think about our “Subconscious”?
“Journey to Self” is our structured coaching program where we take back focus from the outside and delve deep inside to find our inner strength. Focusing on self-acceptance and personal growth
I believe everyone has POWER within them!
Let’s be the POWERHOUSE!
Human, AI, and Personalized User Experience for DB Observability: A Composable Approach
Database users across various technical levels are frequently frustrated by the time-consuming and inefficient process of identifying the root causes of issues. This process often involves navigating multiple systems or dashboards, leading to delays in finding solutions and potential downstream impacts on operations.
The challenge is compounded by the varying levels of expertise among users. It is essential to strike the right balance between specialized and generalized experiences. Oversimplification can result in the loss of critical information, while an overwhelming amount of data can alienate certain users.
Developers and designers are constantly navigating these trade-offs to deliver optimal user experiences. The integration of AI introduces an additional layer of complexity. While AI can provide personalized experiences within databases, it is crucial to maintain user trust and transparency in the process.
The concept of personalized composable observability offers a potential solution. By combining the strengths of human expertise, information balance, and AI-driven personalization, we can create intuitive and user-friendly experiences. This approach allows users to tailor their observability tools and workflows to their specific needs and preferences.