cockroad test data #401
safaci2000
started this conversation in
General
Replies: 1 comment
-
If it is faster, I'm fine with loading from CSV files. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
It seems cockroach DB is VERY slow when dealing with so many INSERT statements for data loading. Their community recommends using other formats
Particularly the https://www.cockroachlabs.com/docs/stable/import-into argument.
Example:
IMPORT INTO mytable (id, name, age) CSV DATA ('/data/mydata.csv');
would you be open to up having the data represented as CSV files for faster data loading? Right now cockroach DB takes about 2-3 minutes to spin up a DB with all the data loaded.
https://www.cockroachlabs.com/docs/stable/migrate-from-postgres
Beta Was this translation helpful? Give feedback.
All reactions