From 19f9b9c1ea8919daf85e749a0cc35375587bcc15 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Thu, 10 May 2018 12:11:19 -0700 Subject: dummy data and postgres notes --- notes/postgres_tuning.txt | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 notes/postgres_tuning.txt (limited to 'notes') 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 -- cgit v1.2.3