iiinova — where your digital self keeps evolving

Xata - Postgres at Scale @xata.io · 24/09/2026

A coding agent wants its own database for every task, created when the work starts and removed when it ends. A shared staging database doesn't survive that for long. Our CEO Monica Sarbu on what to do instead, today 2:50pm PT, Stage 2, WeAreDevelopers San José: "Databases in the Agent Era."

110

Xata - Postgres at Scale @xata.io · 24/09/2026

Live now: Graham walks through Account Observatory, the internal tool our GTM team built on one Postgres database. 30 minutes, then your questions. www.youtube.com/watch?v=9ZH...

youtube.com

AI-native GTM Ops: Account Observatory with Scale-to-Zero Postgres

Xata is a managed Postgres company. Our product lets a team copy a ...

000

Xata - Postgres at Scale @xata.io · 22/09/2026

Our GTM team built an internal tool to stay customer focused as a PLG-first company. Account Observatory pulls PostHog, Pylon and Clarify into one Postgres database. Changes ship from a branch through a pull request. Thu Sep 24, 8:30am PT. Free on YouTube. youtube.com/watch?v=9ZH...

youtube.com

AI-native GTM Ops: Account Observatory with Scale-to-Zero Postgres

Xata is a managed Postgres company. Our product lets a team copy a ...

100

Xata - Postgres at Scale @xata.io · 27/08/2026

Need production data to debug a slow query? Normally, you'd have to isolate & validate data & deploy the fix. With the Xata MCP server and Codex, you just talk to an agent. Branch your Postgres database in seconds regardless of the size and let AI do the debugging. Watch 👇

100

Xata - Postgres at Scale @xata.io · 26/08/2026

Coding agents write and run SQL now. The same connection that lets one fix a query lets it drop a table. The Xata MCP server gives it a branch instead: the agent creates it, works in it against real data, deletes it when the run ends. xata.io/blog/introdu...

230

Xata - Postgres at Scale @xata.io · 20/08/2026

Xata is coming to Azure. Branch-native Postgres. A copy-on-write branch of an existing database in seconds, whether the parent is 1GB or 1TB. Xata branches only incur costs for changed data plus compute while awake. A sleeping branch is basically free. Join the waitlist: xata.io/get/azure

010

Xata - Postgres at Scale @xata.io · 11/08/2026

pgp_sym_decrypt with the wrong key throws "Wrong key or corrupt data". No garbage bytes returned. The PGP integrity check earns its keep when every tenant holds a different key: the wrong key fails the query instead of quietly returning nonsense. Read about it here: xata.io/blog/multi-t...

000

Xata - Postgres at Scale @xata.io · 31/07/2026

Finding a slow query on a Postgres branch, without leaving the terminal. xata branch query-insights ranks that branch's statements by cost, flags the slow ones, and prints the command to inspect any of them. Logs and instance metrics are one command away.

100

Xata - Postgres at Scale @xata.io · 23/07/2026

If every agent and PR gets its own Postgres branch, you're scripting those, not clicking them. So the CLI output has to be parseable. Now it is: piped output is clean plain text, xata branch list --json for anything automated. Boring, but that's the point at scale.

000

Xata - Postgres at Scale @xata.io · 17/07/2026

2TB+ Postgres. Branch it in seconds, query it, delete it. xata scratch (new Xata CLI cmd) forks a disposable branch off your real DB, drops you into psql or runs SQL inline, tears it down on exit. Demo 👇

120

Xata - Postgres at Scale @xata.io · 10/07/2026

pgstream v1.1.1: the replication path now binds and escapes identifiers, slot names, and plugin options, so a crafted name can't break out onto the target. Backported to v0.9.15. Plus wider snapshot restore coverage. github.com/xataio/pgstr...

000

Xata - Postgres at Scale @xata.io · 08/07/2026

Introducing the Xata GitHub App. Connect a repo to your Xata project and every pull request gets its own isolated Postgres branch off main, with production-like data, ready in seconds when the PR opens and gone when it closes.

110

Xata - Postgres at Scale @xata.io · 30/06/2026

Xata is now on Google Cloud. Spin up an isolated Postgres branch from your production data in 3 seconds, in-region in us-central1 (Iowa). Every coding agent, PR, and CI run gets its own production-like database. No shared staging, no migration.

111

Xata - Postgres at Scale @xata.io · 26/06/2026

New Xata region: AWS us-west-2 is live. West coast agents and CI can now run their Postgres branches next to their compute. Same instant branching, scale-to-zero, and pricing as us-east-1. xata.io/docs/changelog#aws-us-west-2-region-support

000

Xata - Postgres at Scale @xata.io · 25/06/2026

We run 100% vanilla Postgres. No fork, no modifications. A deliberate decision from day one to build a platform around Postgres, with branching at the storage layer instead of inside the database. This means the whole Postgres ecosystem just works with Xata.

101

Xata - Postgres at Scale @xata.io · 18/06/2026

Branching gives every engineer and every agent their own Postgres. Now every branch has its own logs. Read, filter, and search them in the console, or match a pattern in one click. Same logs in your terminal with xata branch logs.

231

Reposted by Xata - Postgres at Scale

Xata - Postgres at Scale @xata.io · 17/06/2026

DeltaX, our open-source timeseries and columnar extension for Postgres, just shipped v0.2.1, mostly analytics performance work. A few engineering bits worth sharing:

131

Xata - Postgres at Scale @xata.io · 17/06/2026

DeltaX, our open-source timeseries and columnar extension for Postgres, just shipped v0.2.1, mostly analytics performance work. A few engineering bits worth sharing:

131

Xata - Postgres at Scale @xata.io · 16/06/2026

Postgres CDC has always been a thing you babysit: a CLI in a screen session, secrets in a config file, a pipeline that breaks on the next ALTER TABLE. pgstream v1.1.0 is a step toward running it as a service. K8s probes, JSON logs, and schema changes that flow to the target. xata.io/blog/pgstrea...

xata.io

pgstream v1.1.0: running Postgres replication as a service by Noémi Ványi

What's new in pgstream v1.1.0: env vars in YAML config, JSON logs, Kubernetes health probes, custom TLS for OpenSearch, and fixes for composite primary keys.

020

Xata - Postgres at Scale @xata.io · 11/06/2026

Introducing the latest in Postgres for agentic workloads. Agents can now branch or wake your Postgres database instantly.

111

Xata - Postgres at Scale @xata.io · 08/06/2026

Today, Xata CEO Monica Sarbu joined the Berlin Buzzwords panel "The Agent Era: How AI Agents Are Reshaping Data Platforms," alongside speakers from Snowflake, Elastic, and MotherDuck, on what breaks when agents become the most demanding users of data platforms.

110

Xata - Postgres at Scale @xata.io · 05/06/2026

That sidebar full of "untitled query (3)" you never keep? We reworked the Xata query editor: new queries open as drafts, run and discard, nothing saved. Plus Run selected, per-statement tabs, autosave with AI naming. xata.io/blog/query-editor-v2-a-better-way-to-write-sql-in-xata-console

xata.io

Query Editor v2: A Better Way to Write SQL in Xata Console by Marcello Novelli

We've rebuilt the query editor from the ground up. The new version is faster, smarter, and easier to use.

010

Xata - Postgres at Scale @xata.io · 02/06/2026

We rebuilt how every Postgres branch on Xata is observed: out of a central observability vendor, into a per-cell VictoriaMetrics stack. Nothing crosses cells, so one cell's observability can't break another's. Six weeks of work, no user-visible downtime. Full write-up: xata.io/blog/how-we-...

xata.io

How we rebuilt Postgres branch metrics on VictoriaMetrics by Alexis Rico

How we rebuilt Xata's PostgreSQL branch metrics on a self-hosted VictoriaMetrics stack in six weeks, with zero user-visible downtime.

020

Xata - Postgres at Scale @xata.io · 20/05/2026

Monica + the Xata team are at AWS Summit Hamburg today, in the AWS Startup Zone, Hall 4. If you're thinking about Postgres for agent scale, swing by. Always up for that conversation.

030

Xata - Postgres at Scale @xata.io · 19/05/2026

DeltaX is now public: the TimescaleDB alternative with Apache 2.0. A Postgres extension for columnar storage and time-series compression. Preliminary ClickBench: ~4.7× faster on analytical queries. Star the project: github.com/xataio/deltax

040

Xata - Postgres at Scale @xata.io · 13/05/2026

pgstream v1.0.2 shipped. Stream-mode WAL batching means post-snapshot catch-up stops stalling on bulk-INSERT and DELETE tables (Postgres sink only for now; UPDATE still goes one at a time). Decode-time table filtering inside Postgres via wal2json.

github.com

Release v1.0.2 · xataio/pgstream

⚡ Highlights 🔀 Batch WAL operations in stream mode 🆔 New settings for wal2json plugin: add_tables and filter_tables 🐛 Bug fixes Dependency updates What's Changed 1dc7cc1 Add add_tables and filter...

120

Xata - Postgres at Scale @xata.io · 07/05/2026

Every Xata Postgres branch now has a managed PgBouncer endpoint, in the same memory envelope as the database. Auto-tuned to 0.9 of max_connections. 10,000 client connections per branch. Hibernates with the branch. Append `-pooler` to your branch ID. Writeup: xata.io/blog/a-conne...

xata.io

Postgres connection pooling per branch | Xata by Noémi Ványi

Every Xata Postgres branch includes a built-in PgBouncer pooler in transaction mode. Tuned for serverless and edge, scales to zero with the branch.

131

Reposted by Xata - Postgres at Scale

Tudor Golubenco @tudor.golubenco.org · 30/04/2026

I’ve written a blog post on why and how we built our own distributed storage engine. We’re calling it Xatastor and enables us to scale to a huge number of Postgres instances and branches. It’s based on ZFS and NVMe-oF as key technologies. xata.io/blog/xatasto...

xata.io

Xatastor: ZFS + NVMe-oF for millions of Postgres instances by Tudor Golubenco

Read the technical details of our new distributed storage system, which is the key to scaling to a huge number of Postgres instances.

132

Xata - Postgres at Scale @xata.io · 28/04/2026

Engineers are writing most of their code with AI now. The software engineering profession is not over. The job has split: AI codes, humans engineer. A thread on what changed and what didn't:

100

Xata - Postgres at Scale @xata.io · 24/04/2026

Two new per-branch settings in Xata: 1. Postgres minor version upgrades. Pick your target in the UI or CLI, the API validates it, branch restarts. 2. Password rotation. `xata branch rotate-password` generates a new password, active in under 1 second. Existing connections keep working.

020

Xata - Postgres at Scale @xata.io · 23/04/2026

Code review is a negotiation. The submitter trades shipping speed for the reviewer's confidence that this won't cause pain later. Most new coders don't realize this. They optimize for "does it work" when they should optimize for "can my reviewer approve this safely."

131

Xata - Postgres at Scale @xata.io · 20/04/2026

Remote teams don’t get stronger from more meetings. They get stronger from time together that feels human. At Xata, Club Xata France 2026 was built around good conversations, shared meals, walks, and the unplanned moments in between. Check the full story here: xata.io/blog/club-xa...

010

Xata - Postgres at Scale @xata.io · 15/04/2026

Xata is now open source. Apache 2.0. Postgres platform with Copy-on-write branching at the storage layer. Copy a TB-sized database in seconds. Inactive copies scale to zero automatically. 100% vanilla Postgres.

131

Xata - Postgres at Scale @xata.io · 17/03/2026

Built our product analytics warehouse in vanilla Postgres instead of adding an OLAP stack. Four data sources (Keycloak, PostHog, Orb, internal DB), materialized views to flatten JSONB, pg_cron for refreshes, and database branches to iterate on the schema safely: xata.io/blog/postgre...

xata.io

Postgres as a Data Warehouse: No OLAP Stack Required by Noémi Ványi

Skip the OLAP stack. See how we built a product analytics warehouse on vanilla Postgres with materialized views, pg_cron, and copy-on-write branches.

011

Xata - Postgres at Scale @xata.io · 05/03/2026

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

meetup.com

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

031

Xata - Postgres at Scale @xata.io · 04/02/2026

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

xata.io

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

021

Xata - Postgres at Scale @xata.io · 29/01/2026

Did you know Postgres lets you put **constraints on domains**, not just tables? A domain is a custom data type with rules attached, and Postgres stores those CHECK constraints right in `pg_constraint` linked by `contypid` instead of `conrelid`. A clean way to centralize data rules 👌

xata.io

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.

100

Reposted by Xata - Postgres at Scale

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 12/01/2026

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👇🏽

022

Reposted by Xata - Postgres at Scale

Gülçin Yıldırım J. @apatheticmagpie.bsky.social · 14/01/2026

@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 👀 👇🏽

022

Reposted by Xata - Postgres at Scale

div @me.divyendusingh.com · 19/01/2026

New in xata clone: AI-assisted PII removal config (schema → strict config → validated).

011

Xata - Postgres at Scale @xata.io · 19/01/2026

New in xata clone: xata clone config --mode=ai Feed it your schema + prompt → get a strict, reviewable anonymization config that’s typically more complete than static heuristics. Blog post: xata.io/blog/smarter...

120

Xata - Postgres at Scale @xata.io · 14/01/2026

AI 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:

xata.io

Database branching in the age of AI: One markdown file is all you need by Divyendu Singh

Learn how to enable database branching for coding agents like Claude Code and Amp Code using simple Xata CLI instructions in AGENTS.md. No complex skills required.

010

Xata - Postgres at Scale @xata.io · 12/01/2026

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

xata.io

Optimizing data throughput for Postgres snapshots with batch size auto-tuning by Esther Minano Sanz

Why static batch size configuration breaks down in real world networks and how automatic batch size tuning improves snapshot throughput.

032

Xata - Postgres at Scale @xata.io · 08/01/2026

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`!).

131

Xata - Postgres at Scale @xata.io · 23/12/2025

Moving a production DB is stressful. Don’t. Keep prod on your infra. Stream a logical replica (WAL) into Xata, anonymize PII at ingest, then spin up copy-on-write Postgres branches in seconds - one per PR 👇

xata.io

Modernize Database Workflows Without a Migration. Branch Postgres by Claudiu Dascalescu

Modernize dev workflows: replace your shared, fragile staging database with instant branches for your Postgres database.

010

Xata - Postgres at Scale @xata.io · 20/12/2025

Testing one last change on prod before the holidays…

010