Gülçin Yıldırım J.
@apatheticmagpie.bsky.social
Postgres, books and more.
“For most of history, anonymous was a woman.”
“For most of history, anonymous was a woman.”
Pinned
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
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...
xata.io/blog/club-xa...
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...
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
October 31, 2025 at 1:30 PM
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...
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!
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!
October 21, 2025 at 8:23 PM
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!
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 💙
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 💙
October 21, 2025 at 1:38 PM
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 💙
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 💙
October 19, 2025 at 2:06 PM
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...
Get the schedule: www.postgresql.eu/events/pgcon...
PGConf.EU 2025 Schedule
PGConf.EU 2025 Schedule
www.postgresql.eu
October 17, 2025 at 3:38 PM
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...
Get the schedule: www.postgresql.eu/events/pgcon...
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
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
October 17, 2025 at 3:38 PM
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
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...
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
October 13, 2025 at 12:50 PM
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...
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...
..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
October 10, 2025 at 11:46 AM
🧬 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...
..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...
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...
@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
September 22, 2025 at 11:39 AM
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...
@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.
⚠️ 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.
September 22, 2025 at 10:03 AM
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.
⚠️ 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!
It was a really fun conference and well organized!
September 19, 2025 at 3:52 PM
Loving the photos from @pgdaylowlands.bsky.social 🐘
It was a really fun conference and well organized!
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-...
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
September 17, 2025 at 10:27 AM
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-...
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-...
Reposted by Gülçin Yıldırım J.
Our list of supported extensions is growing every day.
Got any requests?
Got any requests?
September 15, 2025 at 12:31 PM
Our list of supported extensions is growing every day.
Got any requests?
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.
Save money by setting scale-to-zero as the default for a project or override it in the branch settings.
September 16, 2025 at 12:45 PM
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.
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 🇮🇹
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...
##awesome ##postgresql ##conference ##pgday ##pgdaynapoli ##napoli
https://www.postgres...
September 17, 2025 at 10:25 AM
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 🇮🇹
You can still join us at @pgdayna.org 🇮🇹
Reposted by Gülçin Yıldırım J.
🚀 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...
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...
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...
postgreswomen.in
September 15, 2025 at 11:44 AM
🚀 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...
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...
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
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
September 11, 2025 at 9:05 AM
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
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.
Use it as a staging replica with PII automatically obfuscated, a production-ready database, or an ephemeral copy for a quick PR.
September 10, 2025 at 3:26 PM
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.
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-...
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
September 6, 2025 at 5:39 AM
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-...
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-...
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/
Catch it today at PGDay Austria! 🔒🐘
📍 14:10 – 14:55
📍 Room: Sophie
🗓️ Full schedule: pgday.at/schedule/
September 4, 2025 at 8:48 AM
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/
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.
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.
September 4, 2025 at 8:47 AM
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.
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.
🔑 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.
September 4, 2025 at 8:47 AM
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.
🔑 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.
It all starts with Postgres’ secret weapon: MVCC.
MVCC = Multi-Version Concurrency Control.
✅ Reads don’t block writes.
✅ Writes don’t block reads.
September 4, 2025 at 8:46 AM
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.
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/
“Anatomy of Table-Level Locks in PostgreSQL” 🔒
📍 14:10 – 14:55
📍 Room: Sophie
🗓️ Full schedule: pgday.at/schedule/
September 4, 2025 at 8:45 AM
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/
“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.
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
September 4, 2025 at 8:08 AM
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.
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.