As I am using Postgresql a lot these days, I thought I would import a large CSV
file (1 Go) to see if I can play with in-database tools from dplyr & Co. I will
probably need this for work so it’s worth the effort. I started with a Stata
file that I read using haven, and I converted it to a CSV using
data.table::fwrite. This already eated up all my RAM. Now, I’m using csvkit to
import the CSV file into a Postgresql local database. Well, it says a lot about
the process:
