4 ms·
That's a fantastic analysis. I wonder how PostgreSQL performs?
by klaussilveira 3y ago
That's a fantastic analysis. I wonder how PostgreSQL performs?
- eatonphil 3y agoI've done some comparisons for inserts of various data sizes on mariadb, postgres, and sqlite without indexes. I didn't have the patience of OP though to push it to 1B. https://github.com/eatonphil/databases-intuition https://github.com/eatonphil/databases-intuition
- riku_iki 3y agolooks like PGSQL 2x slower for uploading.
- eatonphil 3y agoLooks like I'm not alone. But I don't, and don't think Mark does (he's a MySQL guy I believe), claim to be a Postgres expert. http://smalldatum.blogspot.com/2023/09/trying-out-orioledb.html?m=1 http://smalldatum.blogspot.com/2023/09/trying-out-orioledb.h...
- voidstarcpp 3y agoPostgreSQL supports heap tables, which should blow away SQLite's mandatory clustered index tables in an unindexed insert test.
- deleted 3y ago[deleted]