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