Sign in

Xata - Postgres at Scale

@xata.io
63 followers 1 following 206 posts

With copy-on-write branching, data masking, separated storage & compute , 100% Postgres

PostsRepliesMedia
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 · 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
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 · 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 · 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 · 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 · 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 · 20/12/2025
Testing one last change on prod before the holidays…
010
Xata - Postgres at Scale @xata.io · 12/12/2025
It’s Friday and you want to ship to prod.
010
Xata - Postgres at Scale @xata.io · 12/12/2025
Giving agents access to realistic data via branches should scale the feature development without increasing costs. This shows how you can use the “scale to zero” feature of the Xata platform to improve feature development while keeping costs in check.
110
Xata - Postgres at Scale @xata.io · 10/12/2025
AI agents are “clever” to use available tools like grep, sed to find the relevant code files based on a prompt. Here we experiment with giving AI agent tools to change environment variables in a repository that it checked out and it worked.
130
Xata - Postgres at Scale @xata.io · 09/12/2025
We explored giving AI agents access to compute (via Sandbox) and database via Xata branches and some “commandments” to follow a developer-like workflow.
112
Xata - Postgres at Scale @xata.io · 21/10/2025
Finally, AI won’t replace DBAs, it scales them. Gülçin's talk at the AI Summit walks through how Xata built the open-source Postgres Agent, powered by LLMs and human-written playbooks. From pager fatigue to self-healing clusters for a future that’s safer and saner.
010
Xata - Postgres at Scale @xata.io · 08/10/2025
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.
000
Xata - Postgres at Scale @xata.io · 06/10/2025
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.
000
Xata - Postgres at Scale @xata.io · 04/10/2025
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.
010
Xata - Postgres at Scale @xata.io · 03/10/2025
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.
010
Xata - Postgres at Scale @xata.io · 02/10/2025
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.
000
Xata - Postgres at Scale @xata.io · 30/09/2025
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.
000
Xata - Postgres at Scale @xata.io · 26/09/2025
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.
000
Xata - Postgres at Scale @xata.io · 24/09/2025
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-...
000
Xata - Postgres at Scale @xata.io · 20/09/2025
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-...
030
Xata - Postgres at Scale @xata.io · 19/09/2025
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.
030
Xata - Postgres at Scale @xata.io · 18/09/2025
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.
020
Xata - Postgres at Scale @xata.io · 16/09/2025
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.
021
Xata - Postgres at Scale @xata.io · 15/09/2025
Our list of supported extensions is growing every day. Got any requests?
021
Xata - Postgres at Scale @xata.io · 13/09/2025
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!
020
Xata - Postgres at Scale @xata.io · 11/09/2025
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.
010
Xata - Postgres at Scale @xata.io · 11/09/2025
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
021
Xata - Postgres at Scale @xata.io · 10/09/2025
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.
031
Xata - Postgres at Scale @xata.io · 05/09/2025
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
000
Xata - Postgres at Scale @xata.io · 04/09/2025
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/
011
Xata - Postgres at Scale @xata.io · 04/09/2025
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/
111
Xata - Postgres at Scale @xata.io · 06/08/2025
🚨 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!
011
Xata - Postgres at Scale @xata.io · 31/07/2025
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!
031
Xata - Postgres at Scale @xata.io · 16/07/2025
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...
040
Xata - Postgres at Scale @xata.io · 16/06/2025
We kicked off the day at @berlinbuzzwords.de with a rooftop breakfast for the amazing women speakers. As a proudly female-founded Postgres company, we’re thrilled to support moments like this. 💜 Don’t miss @apatheticmagpie.bsky.social talk at 15:20 (Maschinenhaus room)!
082
Xata - Postgres at Scale @xata.io · 14/05/2025
You can deploy Xata fully in your own AWS/GCP/Azure account. This gives you maximum flexibility, security, and compliance. It also let’s you use your cloud provider credits.
Control plane in our account, dataplane over Kubernetes on your account.
120
Xata - Postgres at Scale @xata.io · 14/05/2025
Xata uses an architecture that separates storage from compute. We’ve partnered with @simplyblock.io in order to integrate their distributed software-defined storage system in the Xata platform.  Simplyblock uses NVMe/TCP and SPDK for ultra-high performance and low latency.
Distributed storage system mounted over NVMe/TCP.
131