iiinova — where your digital self keeps evolving

Reposted by Gülçin Yıldırım J.

Andy Pavlo @andypavlo.bsky.social · 16/09/2026

I am giving a keynote next Tuesday at the "Rows & Columns Summit" in SFO on the history of hybrid transaction/analytical processing (HTAP) database management systems: Broken Dreams, Broken Promises, Broken Marriages. rowsandcolumnssummit.com

071

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 02/09/2026

Wrote about the new system views in PG19. I think this might be the longest I’ve ever spent on a blog 😅 I expanded on the pg_stat_lock (cumulative, cluster-wide lock statistics with one row per lock type). Covered a lot on pg_stat_recovery & pg_stat_autovacuum_scores. All with demo queries! 🐘 🚀

141

Reposted by Gülçin Yıldırım J.

Radim @ boringSQL @boringsql.com · 01/09/2026

@apatheticmagpie.bsky.social wrote the mechanics piece last week (seriously read hers first) she saved me from the boring part. what i did was stress-test it and measure what actually happens. clickhouse.com/blog/postgre...

clickhouse.com

Read your writes: WAIT FOR in PostgreSQL 19 | ClickHouse

PostgreSQL 19's new `WAIT FOR` command enables read-your-writes consistency on asynchronous replicas by letting individual reads wait for a specific WAL position.

121

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 26/08/2026

My favorite newsletter mentioned my latest Postgres blog in its latest issue 🐘 🎉 Go subscribe to Postgres Weekly if you haven’t already! 📝 clickhouse.com/blog/postgre... 🗞️ postgresweekly.com/issues/662

010

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 25/08/2026

Wrote about the new WAIT FOR command coming in PostgreSQL 19. It lets reads on async replicas wait until a specific write has been replayed, so kind of bringing sync replication consistency without making every write synchronous. I could see protocol-aware proxies making a good use of this. #pg19

030

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 03/08/2026

Who could have guessed I would become colleagues with @andypavlo.bsky.social on my first day at @clickhouse.com 💛 🚀

120

Reposted by Gülçin Yıldırım J.

POSETTE: An Event for Postgres @posetteconf.com · 15/07/2026

PostgreSQL 18 introduces temporal keys, NOT ENFORCED constraints & promotes NOT NULL to a first-class constraint. Gülçin Yıldırım Jelínek @apatheticmagpie.bsky.social (Xata), covers it all at POSETTE 2026. 📺Enjoy Gülçin's talk on YouTube: www.youtube.com/watch?v=9e-_... #PosetteConf

011

Reposted by Gülçin Yıldırım J.

POSETTE: An Event for Postgres @posetteconf.com · 17/06/2026

Tune in to Gülçin Yıldırım Jelínek @apatheticmagpie.bsky.social (Xata) at #PosetteConf Livestream 2 on Wed 17 Jun for "What's new with constraints in Postgres 18" and how constraints protect data integrity. Join live to chat with Gülçin in the virtual hallway track on Discord. posetteconf.com

Person wearing glasses and headphones, speaking into a microphone, seated indoors, framed by “POSETTE: An Event for Postgres 2026.”

031

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 30/06/2026

PostgreSQL 18 introduced temporal keys. With the release of PostgreSQL 19 Beta 1, PostgreSQL continues to build on that foundation with even more temporal features. Wrote a blog about WITHOUT OVERLAPS, PERIOD, UPDATE/DELETE ... FOR PORTION OF and more on temporal databases: xata.io/blog/postgre...

Gülçin with shoulder-length dark hair and glasses stands in front of a projection screen, pointing to code text. She is wearing a blue and green patterned short-sleeved shirt and blue jeans. The screen displays a database schema snippet with lines like "valid_period daterange" and "PRIMARY KEY". In the background, there is a dark wall, vertical wooden wall accents, and audio equipment on the left.

042

Reposted by Gülçin Yıldırım J.

Tudor Golubenco @tudor.golubenco.org · 19/05/2026

There’s something I’ve been feverishly working on, and I just turned the repo public: pg_deltax, a fast time-series extension for PostgreSQL. Basically an Apache-licensed Timescale alternative. Please give it a star: github.com/xataio/deltax

ClickHouse: x1.15
pg_deltax: x2.19
TimescaleDB: x10.04

161

Reposted by Gülçin Yıldırım J.

Xata - Postgres at Scale @xata.io · 05/03/2026

Our CTO Tudor Golubenco is speaking tonight at the PostgreSQL Berlin Meetup, hosted at Zalando. The talk: How we reduced CloudNativePG wake-up times from 20+ seconds to sub-second for Xata's scale-to-zero Postgres clusters. 20:15 CET if you're in Berlin: meetup.com/postgresql-m...

meetup.com

PostgreSQL Berlin March 2026 Meetup, Thu, Mar 5, 2026, 6:30 PM | Meetup

Zalando is graciously hosting us for our first Meetup in 2026. And we are doing it a bit different: we have two rooms, and two talks in parallel. This gives you the opportu

031

Reposted by Gülçin Yıldırım J.

Xata - Postgres at Scale @xata.io · 04/02/2026

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...

xata.io

pgstream v1.0.0: Stateless schema change replication by Esther Minano Sanz

A major architectural milestone that removes schema logs and simplifies how pgstream captures and replicates Postgres schema changes

021

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 27/01/2026

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 🐘

Gulcin is womanning the 2ndQ booth, there is also Pavel :)

First time (in the phone archive), 2016. It was only a single track back then and all talks were in Czech with the exception of one English talk.

030

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 17/01/2026

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

000

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 14/01/2026

@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 👀 👇🏽

022

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 12/01/2026

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👇🏽

022

Reposted by Gülçin Yıldırım J.

Xata - Postgres at Scale @xata.io · 08/01/2026

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`!).

131

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 19/12/2025

“..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...

open.substack.com

Break Gender Stereotypes with Picture Books ft. Women in STEM

While scrolling through social media, this graphic caught me eye.

051

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 12/12/2025

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

061

Reposted by Gülçin Yıldırım J.

Xata - Postgres at Scale @xata.io · 11/12/2025

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...

xata.io

What you should know about constraints in PostgreSQL | xata.io by Gulcin Yildirim Jelinek

In this blog, we explore Postgres constraints through the pg_constraint catalog, covering table vs. column constraints, constraint triggers, domains and more.

032

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 08/12/2025

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 🤘🏽

040

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 21/10/2025

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!

060

Reposted by Gülçin Yıldırım J.

Xata - Postgres at Scale @xata.io · 21/10/2025

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 💙

111

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 19/10/2025

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

010

Reposted by Gülçin Yıldırım J.

Xata - Postgres at Scale @xata.io · 17/10/2025

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...

postgresql.eu

PGConf.EU 2025 Schedule

011

Reposted by Gülçin Yıldırım J.

Xata - Postgres at Scale @xata.io · 17/10/2025

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

postgresql.eu

PGConf.EU 2025 Schedule

121

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 13/10/2025

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...

open.spotify.com

Fireworks

000

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 10/10/2025

🧬 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...

nature.com

World’s first AI-designed viruses a step towards AI-generated life

Scientists used artificial intelligence to write coherent viral genomes, using them to synthesize bacteriophages capable of killing resistant strains of bacteria.

010

Reposted by Gülçin Yıldırım J.

Xata - Postgres at Scale @xata.io · 22/09/2025

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...

meetup.com

PostgreSQL September Meetup, Tue, Sep 23, 2025, 6:30 PM | Meetup

We will be hosting our September Meetup. Thanks to Amazon for sponsoring us. Please note that you have to show sign up with your real name and show a Photo ID to the build

031

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 22/09/2025

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.

050

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 19/09/2025

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

040

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 17/09/2025

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-...

xata.io

Making Postgres scale to zero with CNPG by Esther Minano Sanz

How we built activity-aware Postgres clusters that hibernate automatically and save resources

020

Reposted by Gülçin Yıldırım J.

Xata - Postgres at Scale @xata.io · 15/09/2025

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

021

Reposted by Gülçin Yıldırım J.

Xata - Postgres at Scale @xata.io · 16/09/2025

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.

021

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 17/09/2025

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 🇮🇹

020

Reposted by Gülçin Yıldırım J.

Xata - Postgres at Scale @xata.io · 15/09/2025

🚀 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...

postgreswomen.in

Gulcin Yildirim Jelinek - Postgres Women India

Postgres Woman of the Month September 2025 – Gulcin Yildirim Jelinek Introduction: Hello, my name is Gülçin Yıldırım Jelínek. I work at Xata, a modern PostgreSQL platform focused on enabling realistic...

031

Reposted by Gülçin Yıldırım J.

Xata - Postgres at Scale @xata.io · 11/09/2025

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

021

Reposted by Gülçin Yıldırım J.

Xata - Postgres at Scale @xata.io · 10/09/2025

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.

031

Reposted by Gülçin Yıldırım J.

Xata - Postgres at Scale @xata.io · 06/09/2025

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-...

xata.io

From Database Administrator to Database Agent by Gulcin Yildirim Jelinek

Discover how a PostgreSQL DBA’s decade of expertise evolved into designing Xata’s AI-powered Postgres agent, automating monitoring and observability.

021

Reposted by Gülçin Yıldırım J.

Xata - Postgres at Scale @xata.io · 04/09/2025

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/

011

Reposted by Gülçin Yıldırım J.

Xata - Postgres at Scale @xata.io · 04/09/2025

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.

111

Reposted by Gülçin Yıldırım J.

Xata - Postgres at Scale @xata.io · 04/09/2025

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.

111

Reposted by Gülçin Yıldırım J.

Xata - Postgres at Scale @xata.io · 04/09/2025

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.

111