pg_fastload 1.0: Postgres Bulk Load on All Your Cores
A 1 GiB CSV load is not I/O bound, and it never was. Run COPY lineitem FROM ‘/tmp/lineitem.csv’ on a 16-core machine and one backend pins a core at 100% while fifteen cores idle, because read, parse, tuple formation and insert all execute serially inside that single backend. The expensive stage is parsing: a quote-aware […]
