blob: d1e353da43e12854feece9e255dcfe4615cfeee4 (
plain)
1
2
3
4
5
6
7
8
|
For bulk inserts:
- make write-ahead-log larger (eg, 16MB)
- transactions of ~1000+ inserts
- https://www.postgresql.org/docs/current/static/populate.html
- https://www.depesz.com/2007/07/05/how-to-insert-data-to-database-as-fast-as-possible/
- https://stackoverflow.com/questions/12206600/how-to-speed-up-insertion-performance-in-postgresql
|
