[jorin]

postgres (without extensions) is slower for analytical queries since it stores data as rows, not columns. Also, duckdb is an in-memory database so it's more comparable to sqlite than postgres.

[vivzkestrel]

well what was wrong with apache cassandra? isnt that a columnar database too?