Skip to content

Instantly share code, notes, and snippets.

@jasonmitchell

jasonmitchell/postgres-multi-row-insert-results.md

Created February 2, 2023 21:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jasonmitchell/62c54d43b30b8d3c001fe2a7e84905d2 to your computer and use it in GitHub Desktop.
Save jasonmitchell/62c54d43b30b8d3c001fe2a7e84905d2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgres-multi-row-insert-results.md
Batch Size Simple Insert Execution Time (ms) Multi-Row Insert Execution Time (ms) Improvement
1 4 3 33%
10 15 4 275%
50 68 3 2167%
100 133 4 3225%
250 306 6 5000%
500 606 8 7475%
1000 1358 11 12,245%
2500 3527 28 12,496%
5000 6587 56 11,663%
10,000 11,448 95 11,951%
25,000 29,155 225 12,858%
50,000 58,897 481 12,145%
100,000 120,394 1017 11,738%
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment