Carlos Pérez-Aradros (@exekias) header
Carlos Pérez-Aradros (@exekias) profile picture

Software engineer @xata, previously @elastic. Traveler, geek, astrophotographer wannabe, with love for Go, Python, FOSS, Linux and distributed systems.

España
Joined February 2008
Photo by Carlos Pérez-Aradros (@exekias)Photo by Carlos Pérez-Aradros (@exekias)Photo by Carlos Pérez-Aradros (@exekias)Photo by Carlos Pérez-Aradros (@exekias)Photo by Carlos Pérez-Aradros (@exekias)Photo by Carlos Pérez-Aradros (@exekias)Photo by Carlos Pérez-Aradros (@exekias)Photo by Carlos Pérez-Aradros (@exekias)Photo by Carlos Pérez-Aradros (@exekias)Photo by Carlos Pérez-Aradros (@exekias)
Carlos Pérez-Aradros retweeted
the best way to run Postgres and @ClickHouseDB together. Postgres on local NVMe for your app, ClickHouse for analytics, and replication between the two handled for you. ClickHouse Managed Postgres is GA, seeing is believing :) clickhouse.com/blog/managed-…
2
8
1
30
1,262
We've only just started onboarding at @ClickHouseDB, but I'm already loving the energy from @saisrirampur, @iskakaushik, and the rest of the team. They've built an incredible product that's a great match for @xata. So many conversations happening. Stay tuned for what's coming!
Today is a big milestone for our Postgres at @ClickHouseDB ClickHouse Managed Postgres is now GA, and @xata is joining ClickHouse, bringing instant branching, cloning, and agentic capabilities to the service. The vision is simple: a complete Postgres experience, from the first experiment to production at scale. The last three years have been an incredible journey for me personally. And much of it comes down to one conviction: Postgres + ClickHouse is an incredibly powerful combination for solving most data problems in the world. It started with co-founding @PeerDBInc . Our idea was simple: make it incredibly easy to move data from Postgres to ClickHouse. We built a product customers loved, and eventually PeerDB was acquired by ClickHouse. The next chapter was integrating PeerDB into ClickHouse Cloud and scaling the product. Today, what started as a small startup powers Postgres-to-ClickHouse replication for 1,500+ customers. Seeing the incredible affinity between Postgres and ClickHouse, we decided to make a much bigger bet. What if we built a native, fully managed Postgres service within ClickHouse? We were entering one of the most competitive database markets, but believed we could build something very differentiated: fast, enterprise-grade Postgres, natively integrated with ClickHouse. Ten months later, ClickHouse Managed Postgres is GA! Our NVMe-backed Postgres service now supports hundreds of customers, including AI companies like @clay and @physical_int , enterprises like @quintoandar, and many more. And now, another exciting chapter begins with Xata joining ClickHouse. Having been on the founder side of an acquisition with PeerDB, it's been special to now be on the other side, bringing incredible technology and an extremely talented team into ClickHouse. Xata's technology will be integrated into ClickHouse Managed Postgres, bringing instant branching, cloning, scale-to-zero, and capabilities for AI agents. I still think we're just getting started, and are one step closer to the vision of every application being built on Postgres + ClickHouse. More to the future! 🚀 A huge thank you to my customers, my team, and my family who have been an integral part of this journey. Couldn't have been here without them! @tudor_g @monicasarbu @iskakaushik @tbragin @izrailevsky @ceo_clickhouse
5
1
26
1,346
When @monicasarbu called me five years ago, I didn't hesitate. She and @tudor_g had the vision and brought together an incredible team to make it a reality. I'm so grateful for the opportunity to have been part of this journey. And the best is yet to come!
🚀 I’m incredibly excited to share that Xata is joining ClickHouse! Building Xata over the past five years has been an incredible journey. I’m especially proud of the technology we’ve built, the hard engineering challenges we’ve tackled, and the amazing team behind it all.
3
17
612
5 years ago I joined @xata. Startups are never a straight line, it’s been quite a roller coaster, but through every pivot and challenge, we found our way. @xata <> @ClickHouseDB is a match made in heaven. Incredibly proud of what we built and hyped for what’s ahead, stay tuned!
We’re extremely excited to announce that Xata is joining ClickHouse! Blog post: xata.io/blog/xata-is-joining… And the most important details are here in thread.
3
4
21
852
Carlos Pérez-Aradros retweeted
`xata scratch` is one of my fav CLI commands.
A read-only user lets you look at production data. It doesn't let you try anything. xata scratch gives you a throwaway branch for one query, test run or migration, then deletes it.
1
1
4
399
Carlos Pérez-Aradros retweeted
If you're giving every coding agent and every PR its own Postgres branch, you're not clicking those into existence, you're scripting them. So the CLI output has to be readable by a script, or an agent. Now it is. Piped output is clean plain text, and xata branch list --json is the reliable path for anything automated. When branches are getting spun up by scripts and agents, parseable is exactly what you want.
3
1
7
850
Carlos Pérez-Aradros retweeted
Xata is now on @googlecloud 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. Free until Sept 13.
1
4
6
584
Carlos Pérez-Aradros retweeted
We're hiring a Head of Product to join the leadership team at Xata. If you're passionate about building products developers love, turning customer feedback into product direction, shaping product strategy, and working side by side with engineering to bring great ideas to life, we'd love to talk. This is a unique opportunity to help define the future of Postgres for AI workloads at an early-stage company with an experienced team. Come build with us.
1
2
2
5
2,168
Carlos Pérez-Aradros retweeted
Introducing the latest in Postgres for agentic workloads. Agents can now branch or wake your Postgres database instantly.
6
6
2
101
355,867
Carlos Pérez-Aradros retweeted
Over the past couple of months, we’ve sped up significantly the provisioning, branching, and waking-up of @xata Postgres databases. Branch creation times are down from 25+ seconds to ~2 seconds on average. This results in a much smoother experience for you and your agents. Here is a 3 minutes demo.
2
8
1
26
2,496
Carlos Pérez-Aradros retweeted
1000 Postgres branches for $1 @xata Postgres databases are now provisioned, branched, and woken up from scale-to-zero dramatically faster. Fast, practically free copy-on-write branches mean you can spin one up per PR, CI build, agent run, or psql session.
1
5
16
1,574
Carlos Pérez-Aradros retweeted
Built quietly over the past months. Star the repo and run the benchmark: github.com/xataio/deltax
There’s something I’ve been feverishly working on, and I just turned the repo public: pg_deltax (δx) - Fast time-series extension for PostgreSQL. Basically an Apache-licensed Timescale alternative. GitHub link in the thread.
1
2
376
Carlos Pérez-Aradros retweeted
We needed a storage layer that can scale to a huge number of volumes (think millions) for our Postgres platform. Most of the existing storage systems are optimized for a few volumes with really high performance. But we needed the opposite: a very large number of mostly idle volumes. So we wrote our own. It’s called Xatastor and it enables Postgres-per-tenant use cases, “ephemeral” dbs for agents, free tiers, etc. Supports copy-on-write snapshots, clones, and thin provisioning. It’s based on ZFS and NVMe-oF as key technologies. Link with all the details in the first reply.
2
13
3
28
7,747
Carlos Pérez-Aradros retweeted
Today we're open sourcing the Xata platform, a cloud-native Postgres platform. Apache 2.0. - Fast copy-on-write branching. - Automatic scale-to-zero and wake-up on new connections. - 100% Vanilla Postgres. We run upstream Postgres, no modifications. - Production grade: HA, failover/switchover, upgrades, PITR, IP filtering, etc. I’m obviously biased, but I think this is the ideal product for the coding agents era. Code is cheap now, but validating it with realistic data is not simple. Synthetic or seeded data is limited, copying the data with pg_dump takes ages. Also, the more agents do dev work for you, the more important scale-to-zero is. Links to blog post and github below 🧵
9
33
9
197
25,787
Carlos Pérez-Aradros retweeted
pgstream v1.0.0 is here 🎉 A major milestone bringing stateless schema change replication to Postgres CDC. • DDL emitted directly into WAL • No schema logs • Unified snapshot handling Full details 👇 xata.io/blog/pgstream-v100-s…
4
10
589
Carlos Pérez-Aradros retweeted
We wrote up the exact setup that gives every @vercel PR its own production (PII removed) database copy. With Xata dev branches you can now ship database changes like adding or renaming columns without downtime. •Vercel preview per PR + Xata branch per deployment •pgroll keeps old & new Postgres schemas active in parallel •Healthy preview? Run xata roll complete and merge with confidence No downtime. No surprises. Full breakdown with implementation details: xata.io/blog/zero-downtime-s… #postgres #pgroll #xata #vercel #devtools #zerodowntime #backendengineering
2
6
25
3,472
Watching pgroll grow from an idea into what it is today has been a real gift. I'm excited to see where it goes next!
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-5k-stars… #Postgres #opensource #schemamigration
2
5
704
Carlos Pérez-Aradros retweeted
🚀 pgstream v0.7.1 is out! ✨ JSON transformers to transform json/jsonb data with set and delete operations 📊 Snapshot progress tracking ⚡ Wildcard support for snapshots Read the blog here → xata.io/blog/pgstream-v071-u… #Postgres #pgstream #opensource #json #jsonb
5
9
647
Carlos Pérez-Aradros retweeted
On June 16 at Berlin Buzzwords, @apatheticmagpie gave her talk "Anatomy of Table-Level Locks in PostgreSQL" 🧠🔒 MVCC avoids many locks, but DDL statements like ALTER TABLE still require strong locks. Gulcin shared ways to reduce lock duration and strength where possible. She also introduced pgroll, our zero-downtime, reversible schema migration tool! 🚀 📽️ Recording is now live! youtube.com/watch?v=iiaLohVO…
3
6
585