Hacker News new | ask | show | jobs
by dist1ll 454 days ago
150k rows/second is pretty ordinary if you do batching, especially for a machine of that size. I was able to get 250k+ row inserts on a 16vCPU on a table with 16 columns, a third of which are strings >30 bytes. Pretty sure you can push that much higher with COPY.
1 comments

that's true, you can get very far with COPY