I recently had someone ask me why the COPY command is more performant than INSERT INTO. While coming up with an answer, I discovered I was starting from a deficient: I didn’t know how COPY works under the hood. Trying to come up with an answer was at best a guess. Through this post, I hope to narrow that knowledge gap and help myself and others get a deeper understanding of my favorite database.
Hey, a bit off-topic but not sure where else to ask: is there a app for mobile on f-droid that everybody uses for Hacker News? Gilder maybe?