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
Gülçin Yıldırım J.
@apatheticmagpie.bsky.social
Postgres, books and more. “For most of history, anonymous was a woman.”
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! 🐘 🚀
Planet PostgreSQL@planet.postgresql.org · last mo.Gülçin Yıldırım Jelínek: New system views in PostgreSQL 19 https://postgr.es/p/9tF #postgresql
@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...
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.
clickhouse.com
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
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
Planet PostgreSQL@planet.postgresql.org · 2mo agoGülçin Yıldırım Jelínek: Read your writes: WAIT FOR in PostgreSQL 19 https://postgr.es/p/9ta #postgresql
Who could have guessed I would become colleagues with @andypavlo.bsky.social on my first day at @clickhouse.com 💛 🚀
Andy Pavlo@andypavlo.bsky.social · 2mo ago👊I've joined the crew at @clickhouse.com to establish the *ClickHouse Labs* research group. We'll be working side-by-side with ClickHouse engineers to cook up ways to make the system even faster. I'll also be exploring new research topics related to PostgreSQL. clickhouse.com/blog/andy-pa...
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
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
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...
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
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...
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
meetup.com
Belki bir gün bana kendin varırsın 🎵 #turkishfolk #pinhani open.spotify.com/track/7fuEQa...
Spotify – Web Player
open.spotify.com
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...
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
xata.io
Voting for @pg-data.bsky.social talks this weekend 🗳️ So many wonderful proposals, thanks everyone who submitted!
a man in a suit and tie is looking out a window .
ALT: a man in a suit and tie is looking out a window .
media.tenor.com
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 👀 👇🏽
Xata - Postgres at Scale@xata.io · 9mo agoAI agents get useful faster with guardrails, not plugins. Repo playbook: gh issue → xata branch create + xata branch wait-ready → xata branch url (not $DATABASE_URL) → psql repro/verify → fix. Video + write-up:
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👇🏽
Xata - Postgres at Scale@xata.io · 9mo agoBatching is often used to process large volumes of data but a batch size that works in one network setup can perform poorly in another. We applied automatic batch size tuning to Postgres snapshots in pgstream to adapt across different network environments. Check the post 👇 xata.io/blog/postgre...
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...
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.
xata.io
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`!).
“..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...
Break Gender Stereotypes with Picture Books ft. Women in STEM
While scrolling through social media, this graphic caught me eye.
open.substack.com
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...
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.
xata.io
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...
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.
xata.io
Check out the full post here: xata.io/blog/a-codin...
Closing the loop: Building a coding agent that uses Postgres branches by Divyendu Singh
Explore how to build an AI coding agent that follows a full developer workflow, including creating Postgres branches, using a sandbox, fixing bugs, and raising pull requests with Xata, Vercel, and Git...
xata.io
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 Villa Getaway: Club Xata Rome 2025 by Natalia Woroniec
Somewhere between a team retreat and a family holiday, our week in Rome was about connection, ideas, and joy of being in one place together. A reminder of what can happen when the whole team shares th...
xata.io
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 💙