A connection pooler for every Postgres branch, scaling to zero instances with it
Every Xata Postgres branch includes a built-in PgBouncer pooler in transaction mode. Tuned for serverless and edge, scales to zero with the branch.
Every Xata Postgres branch includes a built-in PgBouncer pooler in transaction mode. Tuned for serverless and edge, scales to zero with the branch.
We usually think branching means copying the whole database. With copy-on-write, it doesn't. Let's compare workflows like seeding to DB branching.
Xata core is now available as open source under the Apache 2 license. It adds copy-on-write branching, scale-to-zero compute to Postgres.
AI agents need two infrastructure layers: real-time streaming for fresh data and database branching for sandboxes. How to build both with Postgres.
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.
The 5 best data anonymization tools for development teams in 2026, compared by Git/CI integration, referential integrity, and speed, so you can ship with production-realistic data without risking compliance.
Learn the difference between anonymization and pseudonymization under GDPR, and when reversible data protection is essential for analytics and fraud detection.
Learn how Dynamic Data Masking (DDM) works, its limitations against inference attacks, and why static masking with branching is safer.
Ship faster with Postgres: JSONB, full-text search, trigrams, and cache tables. Add Redis or Elasticsearch only after you measure real production bottlenecks.
A major architectural milestone that removes schema logs and simplifies how pgstream captures and replicates Postgres schema changes
Why static batch size configuration breaks down in real world networks and how automatic batch size tuning improves snapshot throughput.
In this blog, we explore Postgres constraints through the pg_constraint catalog, covering table vs. column constraints, constraint triggers, domains and more.