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
-
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