Postgres Women India (PWI) is a vibrant community dedicated to empowering and uplifting women in the PostgreSQL, AI and Data ecosystem. Our Mission & Vision is to foster an inclusive space where Women professionals, enthusiasts, and newcomers can connect, collaborate, and grow in their journey. Through initiatives like the PWI Upskill Program, Summits, Mentorship sessions, Technical workshops, Bootcamps, and networking opportunities, we aim to bridge knowledge gaps and create a supportive environment for career advancement.
This document provides answers to some of the most frequently asked questions about Postgres Women India—covering our vision, programs, membership, participation, and ways to get involved. Whether you’re a seasoned professional or just beginning your PostgreSQL journey, we hope this resource helps you understand how PWI can support and inspire your growth in the field.
Postgres Women India is a vibrant and dynamic community dedicated to fostering diversity, inclusion, and empowerment within the PostgreSQL, AI, and Data ecosystem in India. Born from the vision of an ardent PostgreSQL evangelist and Tech entrepreneur who believed in creating opportunities for Women in Open-source technology. PWI stands as a beacon for women passionate about data & technology, providing a platform where voices are heard, skills are showcased, and careers in technology can flourish.
To inspire, connect, and empower Women in technology through the lens of PostgreSQL, creating an environment where Women can learn, innovate, and lead in the development and use of database technologies. We aim to provide resources, mentorship, and networking opportunities to Women at all stages of their careers, from students to seasoned professionals.
PWI envisions a future where women play a pivotal role in shaping the evolution of database technologies. Our vision is to create a thriving and inclusive ecosystem where women are equally represented, actively contributing, and leading in PostgreSQL, AI, and Data-driven innovations. We aspire to build a sustainable and supportive community that fosters growth, collaboration, and leadership, ensuring that women have access to opportunities, mentorship, and recognition in the world of open-source technology.
Our community is open to all women and allies who are passionate about PostgreSQL, Data, Open-source technologies, and tech leadership.
We organize a range of big and small initiatives, helping us to foster learning empowerment, growth, inclusivity and diversity the Postgres Ecosystem:
While our primary focus is on supporting and empowering women, we welcome allies who believe in gender diversity and want to contribute to an inclusive tech ecosystem.
You can get involved by:
Yes! We have a mentorship program where experienced professionals guide women in their career paths, technical skills, and open-source contributions.
No, Postgres Woman India is a not-for-profit organization (NFPO), joining our community and participating in most of our events is completely free.
Organizations can support us by:
You can stay connected by:
We always welcome passionate individuals who want to contribute. You can fill out our Volunteer Form (Get Involved – Postgres Women India) or email us at power@postgreswomen.in to express your interest.
Absolutely! Our community is open to all skill levels, from beginners to experts.
We offer beginner-friendly workshops (PWI Upskill Program) and learning resources to help you get started.
Our goal is to:
We regularly share PostgreSQL learning materials, tutorials, and event recordings through our community channels. (Links are given below) Stay tuned for updates!
You can reach out to us via email at power@postgreswomen.in or message us on our social media platforms.
PWI Channels:
Website: https://test.opensource-db.in/wp2/
Linkedin: https://www.linkedin.com/company/postgres-women-india/
Twitter: https://x.com/PostgresWomenIn
In PostgreSQL, table bloat can negatively impact performance by increasing storage requirements and slowing down queries. pg_squeeze is a powerful tool designed to combat this issue by automatically reorganizing tables to reclaim wasted space without requiring downtime. This talk will explore the mechanics of table bloat in PostgreSQL, introduce the capabilities of pg_squeeze, and demonstrate how it helps maintain optimal database performance by performing non-blocking vacuum operations and table maintenance. Attendees will gain insights into how to integrate and configure pg_squeeze in their environments and learn about its advantages over traditional methods like VACUUM FULL. Whether you’re managing a busy production database or looking to improve PostgreSQL performance, this session will provide practical strategies to tackle table bloat effectively.
Features of postgres 17
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.
| In this talk, we will explore the emerging capabilities of vector search and how PostgreSQL, with its pgvector extension, is revolutionizing data retrieval by supporting AI/ML-powered vector-based indexing and search. As machine learning models generate high-dimensional vector embeddings, the need for efficient similarity searches has become critical in applications such as recommendation systems, image recognition, and natural language processing. |
This tech talk delves into the critical world of PostgreSQL query plans, providing attendees with the knowledge and tools to understand, analyze, and optimize their database queries. We’ll begin by defining query plans and emphasizing their crucial role in database performance. We’ll explore the inner workings of the PostgreSQL planner, examining how it leverages various optimization techniques like sequential scans, index scans, joins algorithms (hash join, merge join, nested loop), and more to craft the most efficient execution strategy for a given query.
The core of the talk focuses on practical analysis. Attendees will learn how to visualize and interpret query plans using EXPLAIN and ANALYZE commands, gaining insights into execution time, data access methods, and potential bottlenecks. We’ll demonstrate how to identify common performance issues like missing indexes, inefficient joins, or suboptimal query structures by deciphering the information within a query plan.
Finally, we’ll connect the dots between PostgreSQL’s optimization techniques and the resulting query plans. By understanding how the planner weighs factors like data distribution, table statistics, and available resources, attendees will be empowered to write better queries and proactively optimize their database schema for maximum performance. This session is essential for developers and database administrators seeking to unlock the full potential of PostgreSQL and ensure their applications run smoothly and efficiently.
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.
This keynote will explore how L&D had got transferred from pre AI to post AI era and its efficiency job security?