commit:6274c85493f83c7c1953b50f672d21b2f92301fb
author:Chip Black
committer:Chip Black
date:Wed Dec 21 01:07:47 2022 -0600
parents:77cf2e519c98b6f395ec23569339fb2140b0a200
Update postgres config
diff --git a/postgres/Bastillefile b/postgres/Bastillefile
line changes: +1/-1
index 76d7491..667b933
--- a/postgres/Bastillefile
+++ b/postgres/Bastillefile
@@ -1,4 +1,4 @@
-PKG postgresql15-server
+PKG postgresql15-server postgresql15-contrib
 SYSRC postgresql_enable=YES
 SYSRC postgres_exporter_enable=YES
 SERVICE postgresql initdb

diff --git a/postgres/postgresql.conf b/postgres/postgresql.conf
line changes: +4/-3
index 0bcb3bf..4115d67
--- a/postgres/postgresql.conf
+++ b/postgres/postgresql.conf
@@ -62,7 +62,7 @@ listen_addresses = '*'			# what IP address(es) to listen on;
 					# defaults to 'localhost'; use '*' for all
 					# (change requires restart)
 #port = 5432				# (change requires restart)
-max_connections = 100			# (change requires restart)
+max_connections = 300			# (change requires restart)
 #superuser_reserved_connections = 3	# (change requires restart)
 #unix_socket_directories = '/tmp'	# comma-separated list of directories
 					# (change requires restart)
@@ -124,7 +124,7 @@ max_connections = 100			# (change requires restart)
 
 # - Memory -
 
-shared_buffers = 128MB			# min 128kB
+shared_buffers = 512MB			# min 128kB
 					# (change requires restart)
 #huge_pages = try			# on, off, or try
 					# (change requires restart)
@@ -741,13 +741,14 @@ default_text_search_config = 'pg_catalog.english'
 
 #local_preload_libraries = ''
 #session_preload_libraries = ''
-#shared_preload_libraries = ''	# (change requires restart)
+shared_preload_libraries = 'pg_stat_statements'	# (change requires restart)
 #jit_provider = 'llvmjit'		# JIT library to use
 
 # - Other Defaults -
 
 #dynamic_library_path = '$libdir'
 #gin_fuzzy_search_limit = 0
+pg_stat_statements.track = all
 
 
 #------------------------------------------------------------------------------