Content-Length: 259551 | pFad | http://github.com/postgrespro/postgres/commit/d326d9e8ea1d690cf6d968000efaa5121206d231

7A In COPY, insert tuples to the heap in batches. · postgrespro/postgres@d326d9e · GitHub
Skip to content

Commit d326d9e

Browse files
committed
In COPY, insert tuples to the heap in batches.
This greatly reduces the WAL volume, especially when the table is narrow. The overhead of locking the heap page is also reduced. Reduced WAL traffic also makes it scale a lot better, if you run multiple COPY processes at the same time.
1 parent 2c30f96 commit d326d9e

File tree

6 files changed

+629
-62
lines changed

6 files changed

+629
-62
lines changed

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/d326d9e8ea1d690cf6d968000efaa5121206d231

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy