Just gave SurrealDB 1.0.0, one of the new Rust kids on the block, a try. Goal: compare performance to PostgreSQL.
Both databases were setup on the same machine (x86_64, 8 cores).
Data: a table with 50.000 small rows (~60bytes). One column is a INT value between NULL and 250.
The raw file size on both databases was below 9 MBs.
Query in Postgres:
select count(*) from objects where score > 100;
Query in SurrealDB:
select count() from objects where score > 100 group all
The count result will be 22.000.
Here are the results after a few repeated executions:
Time for creating the index:
I’m kind of disappointed about the result, given the small table size. I can’t see how SurrealDB would scale with bigger setups and wonder about the hype around it.
#surrealdb #postgresql #benchmark