aboutsummaryrefslogtreecommitdiffstats
path: root/notes/postgres_tuning.txt
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2018-05-10 12:11:19 -0700
committerBryan Newbold <bnewbold@robocracy.org>2018-05-10 12:11:19 -0700
commit19f9b9c1ea8919daf85e749a0cc35375587bcc15 (patch)
tree85cf7cf8cafade0ba2551ef2373755591fd7da92 /notes/postgres_tuning.txt
parentb9200623b0be3c8b663c1000b63c3ab581b7d34b (diff)
downloadfatcat-19f9b9c1ea8919daf85e749a0cc35375587bcc15.tar.gz
fatcat-19f9b9c1ea8919daf85e749a0cc35375587bcc15.zip
dummy data and postgres notes
Diffstat (limited to 'notes/postgres_tuning.txt')
-rw-r--r--notes/postgres_tuning.txt8
1 files changed, 8 insertions, 0 deletions
diff --git a/notes/postgres_tuning.txt b/notes/postgres_tuning.txt
new file mode 100644
index 00000000..d1e353da
--- /dev/null
+++ b/notes/postgres_tuning.txt
@@ -0,0 +1,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