Belki bir gün bana kendin varırsın 🎵 #turkishfolk #pinhani open.spotify.com/track/7fuEQa...

pgstream v1.0.0 is out, with a major architectural change. Schema changes are now emitted directly into WAL as logical messages, without schema logs or stored schema state. If you work with Postgres CDC, this might be interesting. Details in the blog 👇 xata.io/blog/pgstrea...

My contribution to the 2016 trend 😄 Apparently the first time I attended #P2D2 was 10 years ago. Over the years I worked at 2ndQuadrant, EDB and now @xata.io. Some things didn’t change: still talking about Postgres, helping organize, womanning booths and having fun 🤩 Pics: today, 2019, 2018, 2016 🐘

Voting for @pg-data.bsky.social talks this weekend 🗳️ So many wonderful proposals, thanks everyone who submitted!

Decided to walk Camino Francés route of Camino de Santiago this October with a feminist group of women. I am so excited!

@divyendusingh.com is doing a great job making agents do all sorts of stuff using databases. In our case with a few simple instructions, they are able to do branching operations, run queries, validate bug fixes and more. The blog posts are paired with demo videos, have a look 👀 👇🏽

Taking database snapshots and moving large volumes of data over the network is something our customers do regularly. While batching is the de facto way to make this efficient choosing the right batch size is non-trivial considering network variability, latency & system load. Read how we solved it👇🏽

If you want to understand how constraint enforcement works internally, @apatheticmagpie.bsky.social breaks it down beautifully in her latest blog:  👉 xata.io/blog/constra...

PostgreSQL stores *all* constraints: check, not-null, PK, FK, unique, exclusion and domain constraints as rows in `pg_constraint` catalog. In Postgres 18, even NOT NULL constraints now get their own entries here (before 18 they lived in `pg_attribute`!).

The best part of the holidays 📚 #books

“..it matters what stories we put in kids’ hands. Picture books that spotlight women in STEM help children expand their ideas about who scientists are, who they can be and where curiosity can lead.” 👇🏽 List of inspiring picture book biographies of women in STEM 📚 open.substack.com/pub/maistory...

Little joys in life: Getting into Postgres Weekly with your blog 🎉 🔗 xata.io/blog/constra... 🐘 postgresweekly.com/issues/628

Postgres constraints are the rules that keep your data clean. Types tell you *what* can be stored but constraints enforce *what must be true*. If a row violates a rule, Postgres rejects it. No silent corruption. A few well-chosen constraints prevent entire classes of bugs. xata.io/blog/constra...

I wrote about Postgres constraints and covered deferrability concept and a few not-so-well-known gems like constraint triggers and domains 💎 xata.io/blog/constra...

Check out the full post here: xata.io/blog/a-codin...

A few days ago my 6yo asked me to play a song from Stratovarius, I think I reached the parental peak. It is only downhill from now on 😅 I didn’t listen to them since college. Rediscovered a piece of my past thanks to my little genie. Now writing a Postgres blog to celebrate my new found joy 🤘🏽

I love the offsites we do twice a year at @xata.io ☀️Building stronger bonds with my colleagues while working on Xata’s roadmap feels quite amazing. I am grateful for this opportunity ☺️ 🇮🇹 xata.io/blog/club-xa...

The first day of PGConf.EU was a blast! 💥 I had the chance to co-organize two community summits: PostgreSQL on Kubernetes and Postgres & AI. Thanks to my co-organizers Floor Drees, Ellyne Phneah and Torsten Steinbach, I had a great time and all went amazingly!

Day 1 at #PGConfEU kicked off with Community Summits! Our own Gülçin Yıldırım Jelínek is co-organizing two of them ☸️ PostgreSQL on Kubernetes Summit 🧠 PostgreSQL & AI Summit Big thanks to the volunteers & speakers who made this happen. Community is what makes Postgres great 💙

Glad to see #pgroll popping up in my timeline 🎉 If anyone has questions or feedback I am here 📝

Then on the main track Esther Minano & Ahmet Gedemenli dive into anonymization and Gulcin on Postgres 18 constraints. Get the schedule: www.postgresql.eu/events/pgcon...

The countdown to #PGConfEU is on ⏳ On Oct 21, @apatheticmagpie is co-hosting two community summits: 🧠 PostgreSQL & AI with Gulcin on DB Agents ☸️ PostgreSQL on Kubernetes with Esther Minano & Andrew Farries

What is your current song fixation? 🍂 Wherever I went I always knew, always knew Till I didn't know Why do I do this to myself every time? I know the way it ends before it's even begun I am the only one at the finish line open.spotify.com/track/3qJImz...

🧬 This is cool! ..designing a whole genome is challenging owing to complex interactions between genes and gene replication and regulation processes. “There are many important biological functions that you can only access if you’re able to design complete genomes.” www.nature.com/articles/d41...

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