RT @heymingwei
With the same 43 million entries loaded (with correct types) into a local PostgreSQL, a SQLite, and a @duckdb, without manually creating any indexes, I run the following simple query, and here is the timing result:

Postgres: 3.5s
SQLite: 6.7s
DuckDB: 0.0067s

Pure magic.