3 ms·
can anyone point to the COPY FROM improvements mentioned that can result in up to 300% performance improvements is it the line in the release notes about "ASCII
by data_ders 3y ago
can anyone point to the COPY FROM improvements mentioned that can result in up to 300% performance improvements is it the line in the release notes about "ASCII string detection"?
- JelteF 3y agoThese are the two relevant patches that I know of (there might be more): 1. https://github.com/postgres/postgres/commit/3838fa269c15706df2b85ce2d6af8aacd5611655 https://github.com/postgres/postgres/commit/3838fa269c15706d... 2. https://github.com/postgres/postgres/commit/121d2d3d70ecdb2113b340c5f3b99a61341291af https://github.com/postgres/postgres/commit/121d2d3d70ecdb21... It causes much less CPU overhead on the receiving side of a copy when receiving big JSON blobs.
- anarazel 3y agoI think the 300% item is "Allow more efficient addition of heap and index pages". The source of the improvement is a number of related improvements around relation extension, see https://postgr.es/m/20221029025420.eplyow6k7tgu6he3@awork3.anarazel.de https://postgr.es/m/20221029025420.eplyow6k7tgu6he3@awork3.a...