News for hackers. Stuff that matters.

A comment on Batch size one billion: SQLite insert speedups, from the useful to the absurd. Parent comment

Re:Batch size one billion: SQLite insert speedups, from the ... by eatonphil on Tuesday September 26, 2023 @11:05AM (#37660459)
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

[ Parent | on HN ]
Re:Batch size one billion: SQLite insert speedups, from the ... by riku_iki on Tuesday September 26, 2023 @04:23PM (#37665320)
looks like PGSQL 2x slower for uploading.
[ Parent | on HN ]
Re:Batch size one billion: SQLite insert speedups, from the ... by eatonphil on Tuesday September 26, 2023 @04:26PM (#37665362)
Looks 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.h...

[ Parent | on HN ]