Gülçin Yıldırım J.
banner
apatheticmagpie.bsky.social
Gülçin Yıldırım J.
@apatheticmagpie.bsky.social
480 followers 310 following 110 posts
Postgres, books and more. “For most of history, anonymous was a woman.”
Posts Media Videos Starter Packs
Pinned
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!
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!
Reposted by Gülçin Yıldırım J.
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 📝
Manages PostgreSQL schema migrations
Reposted by Gülçin Yıldırım J.
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...
PGConf.EU 2025 Schedule
PGConf.EU 2025 Schedule
www.postgresql.eu
Reposted by Gülçin Yıldırım J.
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
PGConf.EU 2025 Schedule
PGConf.EU 2025 Schedule
www.postgresql.eu
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...
Fireworks
open.spotify.com
🧬 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...
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.
www.nature.com
Reposted by Gülçin Yıldırım J.
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...
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
www.meetup.com
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-...
Making Postgres scale to zero with CNPG by Esther Minano Sanz
How we built activity-aware Postgres clusters that hibernate automatically and save resources
xata.io
Reposted by Gülçin Yıldırım J.
Our list of supported extensions is growing every day.
Got any requests?
Reposted by Gülçin Yıldırım J.
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 🇮🇹
Come see Gülçin Yıldırım Jelinek (@apatheticmagpie.bsky.social) talk about "Anatomy of Table-Level Locks in PostgreSQL"!

##awesome ##postgresql ##conference ##pgday ##pgdaynapoli ##napoli

https://www.postgres...
Reposted by Gülçin Yıldırım J.
Reposted by Gülçin Yıldırım J.
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
Reposted by Gülçin Yıldırım J.
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.
Reposted by Gülçin Yıldırım J.
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-...
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.
xata.io
Reposted by Gülçin Yıldırım J.
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/
Reposted by Gülçin Yıldırım J.
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.
Reposted by Gülçin Yıldırım J.
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.
Reposted by Gülçin Yıldırım J.
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.
Reposted by Gülçin Yıldırım J.
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.
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.
xata.io