From cf198ed37b437b5e1c64a29c49810391f40f73d6 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Fri, 29 Jun 2018 11:19:56 -0700 Subject: more postgres notes --- notes/postgres_tuning.txt | 8 -------- 1 file changed, 8 deletions(-) delete mode 100644 notes/postgres_tuning.txt (limited to 'notes/postgres_tuning.txt') 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 -- cgit v1.2.3