mmissoldtw ←
javier ramirez10,230 posts
javier ramirez avatar

javier ramirez

@supercoco9

Developer Advocate at QuestDB and all around happy person. Fan of Open Source,Tech Communities,Data&ML.He/him.Ex-AWS,Ex Google Developer Expert. @j@chaos.social

◷ Joined March 2007▧ 429 Photos and videos
javier ramirez avatar
javier ramirez@supercoco9·Aug 7

You know it is a major release when you have to create 35 new documentation pages and update another ~75 existing pages. QuestDB 10.0 is out, and it is pretty awesome!

We just shipped #questdb 10.0. QWP: one binary protocol for writes and Arrow reads, 3.6x faster ingestion, 220M rows/sec out. Live views in beta. Web Console notebooks, drivable by coding agents. Parquet tables with schema evolution. Enterprise 4.0 cold storage ships next.

Post attachment
javier ramirez avatar
javier ramirez@supercoco9·May 21

My kid, who glides through netflix, disney+, amazon prime, and youtube, was totally puzzled today when I asked her to change the TV channel. Same device, same remote. Completely different mental schema

javier ramirez avatar
javier ramirez@supercoco9·May 13

These are the type of blog posts I would like to be able to write. My colleague @AndreyPechkurov goes deep to explain how we (ahem, he) added Window Joins to QuestDB, and why it outperforms other database engines.

WINDOW JOIN in #questdb is not just syntactic sugar. We published a deep dive into how we parallelized and vectorized it, plus benchmarks against Timescale, DuckDB, and ClickHouse. On the tested workload: 5x faster than the previous QuestDB path. Link in thread 👇

Post attachment
QuestDB avatar
⟳ javier ramirez retweeted
QuestDB@QuestDb·Apr 28

We’re excited to be nominated for the DBTA Readers’ Choice Awards. If #questdb has been useful to you, we’d love your support. Voting is open until May 22. Link in thread 👇

Post attachment
javier ramirez avatar
javier ramirez@supercoco9·Jan 9

How does your database cope with datasets with 6000+ columns? #questdb handled them fine, but struggled to copy data across tables. No more. github.com/questdb/questdb/p…. And this is why you *sometimes* need specialised databases

Jaromir Hamala avatar
⟳ javier ramirez retweeted
Jaromir Hamala@jerrinot·11 Dec 2025

My machine kept freezing when I used async-profile. This is the deepest I've ever gone: debugging a Linux kernel deadlock, performing live surgery on a frozen CPU with GDB, and pulling off a questionable resurrection. Read the full autopsy: questdb.com/blog/async-profi…

javier ramirez avatar
javier ramirez@supercoco9·9 Dec 2025

Sure, hardware is a factor. Back in 2022 we ran the benchmark on an AWS EC2 m5.8xlarge instance with 32 vCPUs, and we now use an r8a.8xlarge (32 vCPUs as well). But the real boost is in the revamp of the whole ingestion layer

javier ramirez avatar
javier ramirez@supercoco9·9 Dec 2025

When I joined #questdb in 2022, data ingestion peaked at ~1 million rows (ts+10 strings + 10 longs) per second on a single instance using the TSBS benchmark. 3.5 years later, we are now ingesting 11.36 million rows/sec. Not too bad!

javier ramirez avatar
javier ramirez@supercoco9·10 Sep 2025

Pero en el inicio de curso, el señor @marecuencopp ha decidido que para inspirar al alumnado de Leganés a que desarrollen sus estudios en esta ciudad los mejores ejemplos son el fútbol (2 veces) y el Taekwondo. Que están muy bien, pero se me quedan un poco cortos. Y así todo.