NOTE: This memorandum is write about PostgreSQL.
I’m interested in the way for to import too many records efficiently. The
COPY FROM query looks good to me.
I like the bulk
INSERT query, because it easy to use. But the bulk
INSERT query requires memory size to buffer records.
COPY FROM query doesn’t require buffering records. The wrote records will buffer at PostgreSQL server. (May it cause I/O wait at PostgreSQL?)