Re:Loading a trillion rows of weather data into TimescaleDB
by feike on Tuesday April 16, 2024 @11:19AM
(#40053124)
Many libraries for python, Rust, golang support COPY BINARY.
The times I've tested it, the improvement is very small as compared to plain copy, or copy with CSV, whereas it does require more work and thought upfront to ensure the binary actually works correctly.
The times I've tested it, the improvement is very small as compared to plain copy, or copy with CSV, whereas it does require more work and thought upfront to ensure the binary actually works correctly.
https://www.postgresql.org/docs/current/sql-copy.html