Club Xata Rome 2025: our biannual reset. We traded Zoom for a shared table and left with sharper plans + stronger bonds.

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 💙

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

Branch settings, faster. We reorganized the page and added search. What changed Search to jump directly to a setting. Logical groups with clear labels. Guardrails to reduce misclicks. Why it helps Quicker navigation. Less guessing, safer edits. Want early access? Ping us and we’ll enable it.

See write latency and replica lag before users do. New performance charts surface: WAL sync time → time to flush WAL to disk (disk/flush latency). Replication lag → how far a standby is behind the primary (freshness). Want early access? Ping us and we’ll switch it on for your account.

Project-level default database now live in Xata. Set one default and we point new connection strings, views, and child branches to it by default. Fewer misroutes and accidental writes to secondary DBs; faster onboarding. Set it in Project Settings → Default database. You can override per branch.

Create a Postgres branch in one screen. Name it → get the branch → run queries. No org/project setup first. Sane defaults now, easy rollback later. Want early access? Ping us and we’ll enable it.

Getting paged at 3 a.m + database operations ≠ heroics. At Berlin Postgres Meetup (Sep 23) we showed our open-source Xata Agent: Autonomously find slow queries, proposes safe fixes, runs on a schedule w/ approvals. As if you have a new database expert colleague. Recap:

Preload extensions once, use them everywhere. Set shared_preload_libraries at the branch level and every database on that branch shares the same foundation. Example: pg_stat_statements, pg_trgm → consistent query stats + text ops across envs. Notes: applies to all DBs on the branch.

PostgreSQL 18 is supported on Xata. Try PG18 in a safe, branch-based workflow: How to start: • Clone with anonymization → test on look-alike data. • Create a PG18 branch → run queries and migrations. • When ready, promote with pgroll for zero-downtime changes.

Thinking about changing your data model? View your schema as a table or UML diagram. When you are ready, use xata roll to apply changes without downtime.

PostgreSQL 18 is here 🎉 🐘 • Async I/O (io_uring/worker), faster reads • More index hits (skip scan, OR) • uuidv7(), virtual generated cols • OAuth2; Ask for Xata access and try PostgreSQL 18.

Shipping Text to SQL you can trust isn’t just prompting. It’s engineering for simplicity. At Xata we use a tiny context, pass schema + current SQL, a focused system prompt, and the right model per task. Fewer moving parts, cleaner UX. Build notes → xata.io/blog/how-we-...

Just dropped: pgstream v0.8.2 🛠️ Now with hstore transformations, role-aware snapshots, and a cleaner CLI. Built for Postgres devs doing CDC, replication, or analytics. Check it out → xata.io/blog/pgstrea... Open source & ready to use.

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

What if your Postgres cluster could hibernate when idle and wake instantly when needed? At Xata, we built exactly that with a CNPG plugin. → Cut costs → Power ephemeral DBs → Open source Full details: xata.io/blog/making-...

Data exploration is easier with the ability to generate SQL from a simple question. No need to worry about syntax. Just dive into the data.

Branch metrics provide insight into CPU, memory, throughput, egress, and more. Use interactive charts to view trends over time or investigate anomalous spikes. Metrics are stored for up to 60 days at no additional cost.

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.

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

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

Xata @ PGDay UK 2025 🐘 Andrew dove into pgroll, our OSS tool for zero-downtime Postgres schema migrations. Great Qs from the community: logical replication, multi-schema & more. Always grateful for the Postgres crowd in London!

You have full control over your branches directly from the console. Adjust the instance size, add replicas, tune compute settings, and modify your Postgres config.

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

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.

@Railway.com + @Xata.io ⚡ One-click PostgreSQL + Node.js + Drizzle, with more than vanilla Postgres: • Copy-on-Write branching • Point-in-Time recovery • Storage/compute separation • HA, redundancy & scale • Extensions: pgvector, PostGIS, & more • Query editor, AI optimisations , observability

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

Now live: AWS Frankfurt (eu-central-1)  • Lower latency for EU users  • Full EU data residency  • Competitive, region-specific pricing Request access today: xata.io/get-access  More details on pricing: xata.io/pricing

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.

⏰ CfPs closing soon for @pgconf.eu Community Events Day! @apatheticmagpie.bsky.social is co-organizing two summits and we’d love your talk proposals: 🤖 PostgreSQL & AI Summit (deadline Aug 31) ☸️ PostgreSQL on Kubernetes Summit (deadline Sept 1) Details in our latest blog: xata.io/blog/pgconfe...

From PR to Postgres! Ellynne Phneah has built something special with Malmö’s PostgreSQL meetup. 🇸🇪 Ahead of the August 19th event (featuring our own Martin Hansen!), we caught up to hear her story. 📖 xata.io/blog/postgre... 📅 Meetup RSVP: tinyurl.com/ytkwvsst

🚨 The Malmö Postgres User Group meetup returns on Aug 19! Xata’s Martin Hansen will share how we run PostgreSQL on Kubernetes at scale using CloudNativePG. 🔗 Details and RSVP: tinyurl.com/ytkwvsst Thanks to Foo Café for hosting and to Ellyne Phneah for making it happen!

The summer edition of the London Postgres Meetup is behind us! Thanks to the organisers for a great evening. Chris Ellis gave a sharp talk on UUIDs, and Andrew Farries introduced pgroll, our open-source tool for zero-downtime schema changes. Always a joy to talk Postgres over pints!

Join us tonight for the summer edition of the London PostgreSQL Meetup! 📍 The Star of Kings, Kings Cross 🕰️ 18:30 start 🗨️ Talks by Andrew Farries (on pgroll + schema migrations) & Chris Ellis (UUID magic) 🥂 Drinks + snacks RSVP: tinyurl.com/5n77sp8t

Just published a deep dive on how every Vercel preview gets a full production database copy. But that's not even the best bit. Want to know how to safely update your database schema add a column, rename a field, even do complex behind‑the‑scenes transformations while production keeps humming?

pgroll just passed 5,000 stars 🎉 What matters more: 🧠 35% of issues are from the community 🔍 Feedback led to real roadmap updates 🔄 Reversible, zero-downtime schema changes for Postgres Thanks for helping shape the project! 🔗 xata.io/blog/pgroll-...

We wanted to see how our Postgres service ranks among the others on the @planetscale.com benchmarks. The blog post reviews in detail the benchmarking methodology, relevancy, fairness, and openness. xata.io/blog/reactio...

🎉 pgroll 0.14 can now modify primary key columns with alter_column operation. A long-standing issue, fixed! Read more here: xata.io/blog/pgroll-... Try it today → github.com/xataio/pgroll #PostgreSQL #pgroll #DatabaseDev

Running a migration but don’t want a version schema? Use --use-version-schema=false in pgroll 0.14 Trade side-by-side rollout for simplicity. Read more here: xata.io/blog/pgroll-... #Postgres #pgroll #DevTools #schemamigration #opensource

You can now name your own version schema 🎯 No more relying on migration file names. Flexible naming with "version_schema:" in YAML. Details 👉 xata.io/blog/pgroll-... #pgroll #Postgres #SchemaMigrations

🔗 "pgroll latest url" gives you a ready-to-use Postgres connection string for the newest schema version. Perfect for CD pipelines 🛠️ More: xata.io/blog/pgroll-... #pgroll #Postgres #DevOps

✨ Upgrading pgroll just became easier! No need to manually fix old migration files for breaking changes. "pgroll update" now auto-fixes outdated syntax (like create_index)! Blog: xata.io/blog/pgroll-... #pgroll #Postgres #DX #OpenSource

🧪 "pgroll validate" is here! Check migration files for syntax that the objects referenced by a migration exist in the target database. Spot issues like missing tables before they break CI/CD. 👉 xata.io/blog/pgroll-... #PostgreSQL #pgroll #DevTools

🚀 pgroll v0.14 is out! New subcommands, more control over version schemas, and smoother upgrades for your pgroll versions. Read the release blog 👉 xata.io/blog/pgroll-... #Postgres #pgroll #SchemaMigrations #DevOps

🚀 We've made pgstream faster than pg_dump/pg_restore for snapshots without sacrificing logical replication or DDL support. We optimized writes, added binary COPY, delayed indexes and made batching smarter. 📖 Full blog: xata.io/blog/behind-... #PostgreSQL #OpenSource #CDC #DDL #snapshot #benchmark

If you're attending Swiss PGDay 🇨🇭 do not miss Xata's talks! @apatheticmagpie.bsky.social will deliver her talk, "Anatomy of Table-level locks in PostgreSQL" 🔐 at 10:20 today and Andrew Farries will talk about "Postgres schema migrations using the expand/contract pattern" 🛠️ tomorrow at 13:00.

Part 2 of our Postgres branching series is live. This time we compare costs across 5 real-world scenarios 💰 • CI/CD previews • High availability • Multi-tenant SaaS • Model training • Ephemeral agent DBs See how Xata, Neon & Supabase compare 📊 xata.io/blog/neon-vs...

🚀 pgstream v0.7.1 is here! ✨ JSON transformers to transform json/jsonb data with set and delete operations 📊 Snapshot progress tracking ⚡ Wildcard support for snapshots Check the blogpost here → xata.io/blog/pgstrea... Let us know what you think, your feedback & contributions are appreciated!

At @berlinbuzzwords.de, @apatheticmagpie.bsky.social gave her talk "Anatomy of Table-Level Locks in PostgreSQL" 🧠🔒 MVCC lets reads and writes run without blocking, but DDL like ALTER TABLE needs stronger locks. 📽️ Watch the full recording here: www.youtube.com/watch?v=iiaL... #bbuzz #postgres