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 daza on Tuesday September 26, 2023 @04:07PM (#37665145)
What do you mean by "row column in Postgres"? It's confusing. Could you please clarify that?
[ Parent | on HN ]
Re:Batch size one billion: SQLite insert speedups, from the ... by Linosaurus on Tuesday September 26, 2023 @04:25PM (#37665345)
Sounds like the initial table has just one row and one column, containing the entire 16mb csv string.
[ Parent | on HN ]
Re:Batch size one billion: SQLite insert speedups, from the ... by ako on Tuesday September 26, 2023 @05:13PM (#37665891)
Correct, at least one row for every time you load a csv file.
[ Parent | on HN ]