Can an AI agent handle your Postgres on-call? @divyendusingh.com from @xata.io is speaking at the Postgres Berlin Meetup tomorrow showing how we’re using LLMs to automate DB diagnostics, fixes, and even PRs. Come see “Xata Agent” in action. 📍 RSVP: www.meetup.com/postgresql-m...

Oh, just saw Neosync was archived: ⚠️ Disclaimer: Neosync has been acquired by Grow Therapy. As a result, this repository is no longer actively maintained. We've been using Neosync transformers in pgstream, so we'll have to find a replacement or extend our own transformers to cover the gaps.

Loving the photos from @pgdaylowlands.bsky.social 🐘 It was a really fun conference and well organized!

I am really proud of the work we did here, finding ways to optimize resources used by database branches and make sure all is safe while we do that! We also open-sourced a CNPG-I plugin for scale-to-zero, so you can also give it a try! 🐘 Read more: xata.io/blog/making-...

Our list of supported extensions is growing every day. Got any requests?

Have a branch you don’t need running all the time? Save money by setting scale-to-zero as the default for a project or override it in the branch settings.

This will be the last time to hear me talk about DDL locks in Postgres this year! And Napoli is still summer ☀️ You can still join us at @pgdayna.org 🇮🇹

🚀 Congrats to @apatheticmagpie.bsky.social for being named Woman of the Month by Postgres Women India! 🎉 She shares her Postgres journey, open-source work on pgroll and pgstream and her role in co-organizing the Postgres on Kubernetes and Postgres & AI Summits. 👉 postgreswomen.in/gulcin-yildi...

Tomorrow at @pgdaylowlands.bsky.social 🐘, @apatheticmagpie.bsky.social speaks at 09:40 on "Anatomy of Table-level Locks in PostgreSQL." She’s given Postgres talks in a church ⛪, and now in… a zoo! 🦒 And don’t miss tonight’s meetup 👉 meetup.com/postgresql-user-group-nl/events/310728717

In Xata, every branch is a full Postgres instance. Use it as a staging replica with PII automatically obfuscated, a production-ready database, or an ephemeral copy for a quick PR.

The DBA role is evolving. What once meant hands-on tuning and constant monitoring can now be scaled through autonomous agents. In our latest post, we explore the journey from DBA to DB Agent and why safety by design matters: xata.io/blog/dba-to-...

If you want to understand Postgres locks beyond the basics, this talk is for you. Catch it today at PGDay Austria! 🔒🐘 📍 14:10 – 14:55 📍 Room: Sophie 🗓️ Full schedule: pgday.at/schedule/

ACCESS EXCLUSIVE is the strictest lock, blocking everything. More pro tips: Don’t mix strong-lock DDL with other operations in the same transaction. Use lock_timeout to prevent cascading lock queues + handle retries gracefully. Locks aren’t about security → they’re about concurrency control.

But here’s the catch → MVCC doesn’t protect you from object locks. That’s where things get interesting. 🔑 Key takeaways: MVCC avoids many issues, but DDL still needs strong locks. Each DDL command has its own lock strength, some block both reads and writes.

In this session, Gülçin will explain how PostgreSQL handles table-level locks, especially those triggered by DDL operations. It all starts with Postgres’ secret weapon: MVCC. MVCC = Multi-Version Concurrency Control. ✅ Reads don’t block writes. ✅ Writes don’t block reads.

If you’re at PGDay Austria today, don’t miss @apatheticmagpie.bsky.social ’s talk: “Anatomy of Table-Level Locks in PostgreSQL” 🔒 📍 14:10 – 14:55 📍 Room: Sophie 🗓️ Full schedule: pgday.at/schedule/

I started working with Postgres in 2012, when being a DBA meant manually tuning queries, planning upgrades and sitting with devs to write better SQL. In this post, I share how those DBA lessons shaped the way we built an AI-powered Postgres agent at @xata.io and how things evolved.

Last day to submit your Kubernetes & Postgres talks! ⏰ @pgconf.eu 🇱🇻

Join developers and AI enthusiasts exploring how PostgreSQL powers AI applications and how AI enhances PostgreSQL - part of Community Events Day at PGConf.EU 2025 in Riga! Register to PGConf.EU now to attend! https://2025.pgconf.... #PostgreSQL #A##PostgreSQL

🚀 Running Postgres on Kubernetes? Building an operator? Contributing upstream? We want your 10-min insights! Submit by Sept 1 to help shape the future of data on K8s. This summit at PGConf.EU Community Events Day is organised by Gülçin Yıldırım Jelinek & Floor Drees 👉 https://2025.pgconf....

Meet Gülçin Yıldırım Jelínek, Ellyne Phneah, and Torsten Steinbach - the organisers of PostgreSQL & AI Summit, a half-day community event at PGConf.EU Submit your 15-minute talk by August 31st and be a part this exciting event in Riga. https://lnkd.in/eA9e... ###PostgreSQL###AI###PGConfEU

Submit your talk to the Summit at the Community Events Day at PGConf.EU. CFP closes on 1 September 👉 https://2025.pgconf.... Do you run Postgres on Kubernetes? Tell us about it. Work with or maintain an operator? We want to hear from you. Think databases don’t belong on K8s? That’s a story too.

⏰ CfPs closing soon for @pgconf.eu Community Events Day! @apatheticmagpie.bsky.social is co-organizing two summits and we’d love your talk proposals: 🤖 PostgreSQL & AI Summit (deadline Aug 31) ☸️ PostgreSQL on Kubernetes Summit (deadline Sept 1) Details in our latest blog: xata.io/blog/pgconfe...

Hello @pgconf.eu folks! This year on Oct 21st, I am co-organizing two summits! And there are only a few days left to submit talk proposals. ⏰ 🤖 AI Summit (Aug 31) → Text-to-SQL, pgvector, copilots, tuning ☸️ K8s Summit (Sept 1) → Operators, scale, production stories 📖 xata.io/blog/pgconfe...

Çok güzel bir podcast buldum 🎙️ “Senem Timuroğlu ve Feryal Saygılıgil, ‘Sözcüklerin Cinsiyeti’ adlı podcast serisinde dil ve sözcükler üzerine düşünüyor; sözcüklerin felsefi, edebi, tarihsel boyutlarıyla cinsiyetli bagajları üzerine konuşuyor.” open.spotify.com/episode/4He8...

From PR to Postgres! Ellynne Phneah has built something special with Malmö’s PostgreSQL meetup. 🇸🇪 Ahead of the August 19th event (featuring our own Martin Hansen!), we caught up to hear her story. 📖 xata.io/blog/postgre... 📅 Meetup RSVP: tinyurl.com/ytkwvsst

🚨 The Malmö Postgres User Group meetup returns on Aug 19! Xata’s Martin Hansen will share how we run PostgreSQL on Kubernetes at scale using CloudNativePG. 🔗 Details and RSVP: tinyurl.com/ytkwvsst Thanks to Foo Café for hosting and to Ellyne Phneah for making it happen!

🎉 For the second year in a row, we're hosting a challenge to test PostgreSQL 18 pre-releases 🧪 Help improve Postgres by testing the beta versions. In return, you could win a free ticket to PgDay Lowlands and earn your spot on the legendary Wall of Testers Details: 2025.pgday.nl/testing-pg

🎟️ PGX and CYBERTEC are each giving away a free ticket to PGDay Lowlands (Sept 12, Rotterdam)! These tickets are reserved for people underrepresented in the PostgreSQL community. To apply, just send a short email to [email protected] before September 1 #PostgreSQL #DiversityinTech

Bu saatte, diğer şehirlerde olduğu üzere İstanbul’da da hafif bir sis olur, sokak lambaları ölgün sarı bir ışık yayardı. Apartmanların karanlık kapılarından gelen kadın sesleri duyulur, duvarlar boyunca yükselen pencereleri aydınlık kaplardı.

Just published a deep dive on how every Vercel preview gets a full production database copy. But that's not even the best bit. Want to know how to safely update your database schema add a column, rename a field, even do complex behind‑the‑scenes transformations while production keeps humming?

Günlerin köpüğü 🌊 #istanbul

Looking forward to attending @pgdayna.org for the first time! 🇮🇹

Glad to be part of the pgroll project ⭐️ In the blog, I share what I’ve learned over the past year and how the product has evolved by incorporating real feedback from the field. #pgroll

Not to brag or anything 😅

Ayşe Kaya ile Havuz Sahnesinde Buluşmaya Hazır mısın? 🎙 Keynote 📍 Havuz | 🕒 09:45 📅 26 Temmuz Cumartesi • İPA Kampüs Florya MIT mezunu ve SevenX Labs kurucu ortağı Ayşe Kaya, yapay zeka ve analitik deneyimlerini ilham verici bir konuşmayla paylaşıyor.

Diva 2025’in konuşma programı açıklandı! 🎉 Teknoloji, yapay zekâ ve topluluk ruhunu bir araya getiren bu özel günde sen de bizimle ol. 26 Temmuz’da ilham veren konuşmalar ve atölyelerle dolu bir gün bizi bekliyor. 💖 Konferans programı ve daha fazlası için: 2025.divaconf.com/schedule

🎉 pgroll 0.14 can now modify primary key columns with alter_column operation. A long-standing issue, fixed! Read more here: xata.io/blog/pgroll-... Try it today → github.com/xataio/pgroll #PostgreSQL #pgroll #DatabaseDev

Running a migration but don’t want a version schema? Use --use-version-schema=false in pgroll 0.14 Trade side-by-side rollout for simplicity. Read more here: xata.io/blog/pgroll-... #Postgres #pgroll #DevTools #schemamigration #opensource

The ParadeDB BM25 index brings Elastic-style full-text search to Postgres, powered by our custom Postgres-native LSM tree. Dive into how we built it: www.paradedb.com/blog/lsm_tre...

You can now name your own version schema 🎯 No more relying on migration file names. Flexible naming with "version_schema:" in YAML. Details 👉 xata.io/blog/pgroll-... #pgroll #Postgres #SchemaMigrations

🔗 "pgroll latest url" gives you a ready-to-use Postgres connection string for the newest schema version. Perfect for CD pipelines 🛠️ More: xata.io/blog/pgroll-... #pgroll #Postgres #DevOps

✨ Upgrading pgroll just became easier! No need to manually fix old migration files for breaking changes. "pgroll update" now auto-fixes outdated syntax (like create_index)! Blog: xata.io/blog/pgroll-... #pgroll #Postgres #DX #OpenSource

PGDay.UK 2025 schedule is up! pgday.uk/events/pgday... The CfP team did a great job again this year. We'd like to thank @apatheticmagpie.bsky.social , @bilge.bsky.social , Dave Pitts and Alastair Turner for their hard work! Registration is one-click away! 2025.pgday.uk/registration/

🧪 "pgroll validate" is here! Check migration files for syntax that the objects referenced by a migration exist in the target database. Spot issues like missing tables before they break CI/CD. 👉 xata.io/blog/pgroll-... #PostgreSQL #pgroll #DevTools

🚀 pgroll v0.14 is out! New subcommands, more control over version schemas, and smoother upgrades for your pgroll versions. Read the release blog 👉 xata.io/blog/pgroll-... #Postgres #pgroll #SchemaMigrations #DevOps

🚀 We've made pgstream faster than pg_dump/pg_restore for snapshots without sacrificing logical replication or DDL support. We optimized writes, added binary COPY, delayed indexes and made batching smarter. 📖 Full blog: xata.io/blog/behind-... #PostgreSQL #OpenSource #CDC #DDL #snapshot #benchmark

If you're attending Swiss PGDay 🇨🇭 do not miss Xata's talks! @apatheticmagpie.bsky.social will deliver her talk, "Anatomy of Table-level locks in PostgreSQL" 🔐 at 10:20 today and Andrew Farries will talk about "Postgres schema migrations using the expand/contract pattern" 🛠️ tomorrow at 13:00.

You want to do database branching but all the different pricing options confuse you? Take a look at our in-depth branch pricing comparison blog we’ve just published which goes through real-world use cases and compares @xata.io, Neon and Supabase. #postgres #copyonwrite

Gülçin Yıldırım Jelinek (Xata) will talk about the anatomy of table-level locks in #PostgreSQL. Put your science goggles on, it's investigation time: 2025.pgday.nl @apatheticmagpie.bsky.social