2026-01-28 –, 105
Language: English
PostgreSQL 18 introduced significant enhancements to constraints, your first line of defense for maintaining data integrity. This talk focuses on the new capabilities brought by version 18, including temporal PK/UK and FKs, NOT NULL constraints being promoted to first-class constraints, new NOT ENFORCED constraints, and improved support for partitioned tables. We’ll look at what’s new, why it matters, and how to apply these features in real-world systems.
We’ll begin with a brief refresher on the different types of constraints to help you get the most out of PostgreSQL’s declarative integrity model by looking at the pg_constraint catalog.
Then we’ll go into the details of what’s new in PostgreSQL 18 and what you should take away from these changes.
Gülçin started working with Postgres at a startup in 2012 and was amazed by how powerful it truly is! Over the years, she has actively contributed to the PostgreSQL community by organizing conferences, delivering talks, and engaging as a dedicated community member. In recognition of her commitment, Gülçin was elected to the PostgreSQL Europe Board in 2017 and is now recognized as a PostgreSQL Contributor.
Fueled by her passion for PostgreSQL automation and cloud technologies, Gülçin took on the role of Cloud Services Manager and led cloud development efforts at 2ndQuadrant, which was later acquired by EDB in 2020. Committed to fostering diversity and inclusion, she is an integral part of Postgres Women, advocating for increased representation of women in technical communities.
Currently, Gülçin is a Staff Database Engineer at Xata, where she continues to explore her interests in PostgreSQL. In addition to her engineering work, she is one of the co-founders of Kadın Yazılımcı (Women Developers of Turkey) and has led the core team for more than 10 years. In 2023, she launched Diva: Dive into AI as a Kadın Yazılımcı initiative and has been part of the organizing team since.
She is an active member of the Postgres community, dedicated to contributing to the longevity and health of the project. Gülçin lives in Prague and has been the co-founder and organizer of the monthly Prague PostgreSQL Meetup for over seven years.