My day job is Senior Solutions Architect at Crunchy Data, which I came to via a long history as a database administrator (DBA). I’m a PostgreSQL Europe Board member and I chair the PostgreSQL Europe Diversity Task Force. I’ve just been recognised as a PostgreSQL Contributor, which I’m really proud of. I live in a little village in the French Alps with my family and our 2 rescue dogs where I love cycling and mountain biking.
Completely by accident! I had been an Oracle DBA for 20 years when the company I was working for decided to use PostgreSQL for their next project. Since I was the “database expert”, it was my job to learn how to use Postgres and then teach the rest of the team about it. I went to some Postgres events to help me to get up to speed, and quickly became involved with the Postgres community.
Being nominated for and elected to the PostgreSQL Europe Board earlier this year was a really proud moment for me. It’s a huge privilege to be able to work on behalf of the community in that way.
The contribution that I’m most proud of is forming the PostgreSQL Europe Diversity Task Force. I’m working with a committee of fantastic volunteers who are all really enthusiastic about making sure the PostgreSQL Europe community is a diverse and welcoming space where everyone feels valued.
Whether it’s a tricky technical problem or any other challenge that comes up, I can always talk it through and get help from one of my friends in the PostgreSQL community. That sounds really sickly sweet, but it’s true!
As well as the ways I’ve already mentioned, I love being involved with PostgreSQL conferences. I’m on the PGConf.EU organisation team, I’ve chaired the talk selection committee for several events, and I volunteer to help out at events whenever I can. It’s very rewarding and it’s a great way to get to know people and feel involved with the community. I also love to give talks at PostgreSQL and developer events to spread the love for PostgreSQL and for databases in general!
Although I haven’t been involved in any official mentoring schemes (yet!) I’ve received a lot of help from, and try to give support to, other women in the PostgreSQL community. Lætitia Avrot is the first “Postgres Person” that I met when I started my Postgres journey, and she went out of her way to make sure I felt welcomed and included. It made a huge difference to me, and we went on to become colleagues and good friends. My goal, whenever I meet a new member of the community, is to be as welcoming and helpful as Lætitia was to me.
Believe in yourself, and surround yourself with people who believe in you too.
I always find this question hard to answer, because there are so many PostgreSQL resources out there, and it depends what level you’re at, what kind of learning resources you like best etc.
If you like reading blog posts, Planet PostgreSQL could be a good place to start – it aggregates blogs from lots of different people in the PostgreSQL community, so you might find one or more that you want to follow.
There’s no substitute for in-person events for watching talks and connecting with people, but a lot of the PostgreSQL conferences also make talks available after the event. Talks from some of the conferences under the PostgreSQL Europe umbrella can be found here, for example.
Partitioning has become more and more useful and robust over the previous releases. The next big step for me, and the one that would make me much more confident recommending partitioning to customers as a strategy for managing large tables, would be global indexes on partitioned tables.
The PostgreSQL Europe Diversity Task Force is going to take up a lot of my time and energy for the foreseeable future. The committee will be meeting in person during PGConf.EU so we can make solid plans – hopefully we’ll have exciting news to share very soon after that!
Sharing experiences with and supporting my PostgreSQL colleagues, and working together to make sure the whole PostgreSQL project continues to be successful.
PostgreSQL is my career and my hobby, and it’s where a lot of my friends are so it does tend to take up a lot of my time! Fortunately, I have a lovely family that reminds me to switch off the computer and spend time with them doing the things that we enjoy like getting out on our bikes and taking walks in the mountains.
Welcome to the PostgreSQL community! If there’s anything you’re not sure about or need help with, don’t hesitate to reach out and ask a question or even just say “hi”.
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.