3 ms·
I'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
by eatonphil 3y ago
I'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...