If you insert tuples with COPY into a table created or truncated in the
same transaction, at the end of the COPY it calls heap_sync.
But there cases were people use COPY in a loop with a small amount of data
in each statement. Now it is calling heap_sync many times, and if NBuffers
is large doing that gets very slow.
Could the heap_sync be safely delayed until the end of the transaction,
rather than the end of the COPY?
Cheers,
Jeff