Xata.io

Don't miss the upcoming Prague PostgreSQL Meetup on Monday, February 24 at 17:30, hosted by AWS Prague in their Karlin office. Pavlo Golub will present on the new features of pgwatch v3, and Belma Canik will discuss AI-powered text search with pgvector for PostgreSQL. Attendees can learn, network, and enjoy light refreshments. Check out the LinkedIn event for more details: https://lnkd.in/ecBgUdm3

If you’ve ever wanted a more modern way to build extensions for PostgreSQL but found C too dated and Rust too intricate, pgzx might be the solution for you. In our latest Postgres Café episode, Tudor Golubenco discusses the Zig programming language and explores how pgzx further helps developers with built-in memory checks, a streamlined comptime feature, and a refreshingly direct way to call Postgres internals. Whether you’re migrating an existing codebase or building something entirely new, pgzx strikes a good balance of safety, performance, and flexibility. Watch now: https://lnkd.in/eJX46Q4D

🔍 Curious about solving schema replication challenges in PostgreSQL? Discover pgstream, our open-source Change Data Capture (CDC) tool for PostgreSQL, designed to capture both schema (DDL) and data changes seamlessly. In Episode 3 of Postgres Café, Sarah Conway and Gülçin Yıldırım Jelínek chat with Esther Miñano Sanz about how pgstream tackles common replication issues, manages lag with Kafka, and integrates with tools like OpenSearch. 🎥 Watch the episode: https://lnkd.in/dWUbQE9Y Want even more? Check out the slides from Esther’s talk at Prague PostgreSQL Developer Day (P2D2) for a deeper dive into how pgstream works and its real-world applications. Slides available here: https://lnkd.in/dGa2YyUU 

We’ve just released pgroll v0.9, our open-source Postgres schema migration tool built around multi-version, lock-safe migrations. This update delivers one breaking change (renaming columns now uses a rename_column operation), and adds several improvements that make defining table-level constraints more straightforward. From primary keys to exclude constraints, you can now manage them all in a single create_table operation, which simplifies complex migrations and keeps your database tidy. On top of that, we’ve boosted CLI feedback so you can see real-time progress on those longer data backfills. If you’re juggling frequent schema changes and can’t afford downtime, pgroll might be exactly what you need. We’re excited to see how these new features improve your workflow. Head over to the blog for the details, and let us know what you think or how you’re using pgroll in your own projects! https://lnkd.in/eK5prY_i

Scaling PostgreSQL? Sharding? High-throughput workloads? In the latest #PostgresCafe episode, Gülçin Yıldırım Jelínek (Xata.io) and Sarah Conway (Data Bene) sit down with Stéphane Carton (Data Bene) to break down how #CitusData simplifies distributed #PostgreSQL, enabling seamless horizontal scaling, performance boosts, and high availability. Check it out 👇 and at https://lnkd.in/d-KfVvc5

Today we are celebrating the incredible achievements of Gülçin Yıldırım Jelínek, who has recently been recognised as a PostgreSQL contributor on the official #PostgreSQL Community Contributors page (https://lnkd.in/gVqETu2g). Her contributions to the PostgreSQL community go far beyond technical expertise. As a former Board Member of Postgres Europe, she has played a pivotal role in shaping the organisation's direction. She co-founded the Prague PostgreSQL Meetup in 2018 and has been an essential organiser for major PostgreSQL conferences such as PGConf.EU, Prague PostgreSQL Developer Day, and PGDay Istanbul. Her leadership also includes mentoring women and underrepresented groups in tech through initiatives like Kadin Yazilimci (Women Devs) and Postgres Women. Gulcin’s dedication to fostering a diverse and inclusive tech community is truly inspiring. As a key organiser and speaker at numerous events and conferences, she has made significant strides in promoting diversity within the PostgreSQL ecosystem. She now serves as part of the PostgreSQL Europe Diversity Committee as well. At Xata, we are fortunate to work alongside someone whose impact is felt not only within the PostgreSQL community but also in the broader tech world, where she continues to inspire and mentor the next generation of database enthusiasts. Congratulations Gulcin 🎉

We 💜 the #PostgreSQL community and are excited to be joining those of you attending P2D2 next week in Prague for another insightful and engaging event. Please stop by our booth and chat with our team to learn about our new developments around our Postgres solutions 🐘

When performing schema changes in PostgreSQL, lock contention can lead to significant downtime and performance issues. In Gülçin Yıldırım Jelínek's latest blog, she covers practical strategies for reducing locking impact in production systems. ✅ Use CONCURRENTLY commands like CREATE INDEX CONCURRENTLY and ALTER TABLE DETACH PARTITION CONCURRENTLY to avoid heavy locking, allowing other operations to proceed smoothly. ✅ Break down large DDL operations into smaller steps. For example, adding a NOT NULL column in stages and adding a nullable column with a DEFAULT first, then populating any NULL values and finally adding NOT NULL constraint. ✅ Stay up-to-date with the latest PostgreSQL versions. Newer releases include optimisations that reduce locking and make schema modifications faster and less disruptive. Check out the full blog to learn more about how you can improve PostgreSQL performance and ensure minimal downtime during schema changes. https://lnkd.in/e-Sn78wM 

When performing schema changes in PostgreSQL, lock contention can lead to significant downtime and performance issues. In Gülçin Yıldırım Jelínek's latest blog, she covers practical strategies for reducing locking impact in production systems. ✅ Use CONCURRENTLY commands like CREATE INDEX CONCURRENTLY and ALTER TABLE DETACH PARTITION CONCURRENTLY to avoid heavy locking, allowing other operations to proceed smoothly. ✅ Break down large DDL operations into smaller steps. For example, adding a NOT NULL column in stages and adding a nullable column with a DEFAULT first, then populating any NULL values and finally adding NOT NULL constraint. ✅ Stay up-to-date with the latest PostgreSQL versions. Newer releases include optimisations that reduce locking and make schema modifications faster and less disruptive. Check out the full blog to learn more about how you can improve PostgreSQL performance and ensure minimal downtime during schema changes. https://lnkd.in/e-Sn78wM 

In Episode 3 of Postgres Café, Sarah Conway and Gülçin Yıldırım Jelínek chat with the creator of pgstream, an open-source change data capture (CDC) tool that addresses PostgreSQL’s biggest gaps. While native replication tools handle data changes, schema updates (DDL) often require manual fixes. pgstream solves this by replicating both schema and data changes. Learn how pgstream solves schema replication challenges, manages lag with Kafka integration, and powers modular workflows for tools like OpenSearch. Real-world use cases include Postgres-to-OpenSearch replication for search and S3 cleanup workflows. 👉 Watch the full episode: https://lnkd.in/eJ-vsaTU