diff options
| author | Bryan Newbold <bnewbold@robocracy.org> | 2018-06-29 11:19:56 -0700 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@robocracy.org> | 2018-06-29 11:19:56 -0700 |
| commit | cf198ed37b437b5e1c64a29c49810391f40f73d6 (patch) | |
| tree | 83265b7040f2d7538687f8101e3349fbf051f33a /notes/postgres_tuning.txt | |
| parent | d304edc994bd1c0620c500a1cda8b948051f84f1 (diff) | |
| download | fatcat-cf198ed37b437b5e1c64a29c49810391f40f73d6.tar.gz fatcat-cf198ed37b437b5e1c64a29c49810391f40f73d6.zip | |
more postgres notes
Diffstat (limited to 'notes/postgres_tuning.txt')
| -rw-r--r-- | notes/postgres_tuning.txt | 8 |
1 files changed, 0 insertions, 8 deletions
diff --git a/notes/postgres_tuning.txt b/notes/postgres_tuning.txt deleted file mode 100644 index d1e353da..00000000 --- a/notes/postgres_tuning.txt +++ /dev/null @@ -1,8 +0,0 @@ - -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 |