Performance Articles
Performance engineering for analytics: Query optimization, columnar storage, and vectorized execution. Real benchmarks and production latency wins.
One Billion Rows
At 1 billion rows, every shortcut comes back to collect interest. Here's how we achieved sub-second queries with near-realtime ingestion.
Pruning Top-N Queries
A deep dive into DuckLake PR #668 and how Top-N dynamic filter pruning turns ORDER BY + LIMIT from full scans into metadata-driven execution.
Lessons from Search
Real-time analytics faces the small-file problem search engines solved. DuckLake's tiered compaction brings those merge strategies to streaming analytics.
Stop Batching Analytics
Why we're forcing analytics through complex batch pipelines when append-only data should work like logs. The warehouse constraint that stopped making sense.
Speed Shapes Understanding
Speed isn't just a luxury: it's the difference between insight and inertia. We've been deep in TPC-H benchmarks, tuning our analytical engine for AI agents.
NetQuack 4000x Faster
We rewrote NetQuack DuckDB extension, replacing regex with character parsing. Result: 4000x faster—37 seconds down to 0.012 seconds.
Rethinking the Lakehouse
Breaking down our storage and query architecture: why we're leaning into Apache Iceberg and why DuckDB is emerging as our real-time query engine of choice.
Interested in learning more about Altertable?
Apply for AccessStay Updated
Get the latest insights on data, AI, and modern infrastructure delivered to your inbox
Our Manifesto
The stack is broken: slow, fragmented, reactive. Our manifesto is a call to wake it up. It's time for data that works like your best teammate: always on, always thinking, always ready to help.
Read Manifesto