Author | Lightnews

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 8d

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!

5

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

Xata - Postgres at Scale @xata.io · 8d

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 💙

1 1 1

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

Glad to see #pgroll popping up in my timeline 🎉

If anyone has questions or feedback I am here 📝

Tom Dörr @tom-doerr.bsky.social · 11d

Manages PostgreSQL schema migrations

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

Xata - Postgres at Scale @xata.io · 12d

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

www.postgresql.eu

1 1

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

Xata - Postgres at Scale @xata.io · 12d

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

www.postgresql.eu

1 1 2

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 16d

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

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

🧬 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

1

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

Xata - Postgres at Scale @xata.io · Sep 22

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

1 3

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

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.

5

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

Loving the photos from @pgdaylowlands.bsky.social 🐘

It was a really fun conference and well organized!

4

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

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

2

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

Xata - Postgres at Scale @xata.io · Sep 15

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

1 2

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

Xata - Postgres at Scale @xata.io · Sep 16

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.

1 2

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

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

PGDay Napoli @pgdayna.org · Sep 16

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

2

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

Xata - Postgres at Scale @xata.io · Sep 15

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

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

1 3

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

Xata - Postgres at Scale @xata.io · Sep 11

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

1 2

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

Xata - Postgres at Scale @xata.io · Sep 10

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.

1 3

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

Xata - Postgres at Scale @xata.io · Sep 6

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

1 2

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

Xata - Postgres at Scale @xata.io · Sep 4

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/

1 1

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

Xata - Postgres at Scale @xata.io · Sep 4

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.

1 1 1

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

Xata - Postgres at Scale @xata.io · Sep 4

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.

1 1 1

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

Xata - Postgres at Scale @xata.io · Sep 4

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.

1 1 1

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

Xata - Postgres at Scale @xata.io · Sep 4

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/

1 1 1

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · Sep 4

🔗 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

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · Sep 4

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

1 2 5