Commitc015cb1

committed

Merge branch 'nik-pg-config-additions' into 'master'

feat: PG config improvementsSee merge request postgres-ai/database-lab!80

2 parents49a9777 +a7e575b commitc015cb1Copy full SHA for c015cb1

File tree

-1

lines changed

-1

lines changed

Lines changed: 9 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -14,6 +14,12 @@`
`14`	`14`	`#logging_collector`
`15`	`15`	`#log_directory`
`16`	`16`
	`17`	`+# Load pg_stat_statements and auto_explain for query analysis`
	`18`	`+shared_preload_libraries = 'pg_stat_statements, auto_explain'`
	`19`	`+`
	`20`	`+# Avoid running autovacuum in the "transaction ID wraparound prevention" mode`
	`21`	`+autovacuum_freeze_max_age = 1000000000`
	`22`	`+`
`17`	`23`	`listen_addresses = '*'`
`18`	`24`
`19`	`25`	`log_destination = 'stderr'`
`@@ -24,7 +30,9 @@ log_connections = on`
`24`	`30`	`## If you want to have more clones use a lower value.`
`25`	`31`	`shared_buffers = '1GB'`
`26`	`32`
`27`		`-# detect idle clones`
	`33`	`+# To be able to detect idle clones, we need to log all queries.`
	`34`	`+# We are going to do so with duration.`
	`35`	`+# TODO: switch to "auto_explain.log_min_duration = 0" instead (set log_min_duration_statement = -1)`
`28`	`36`	`log_min_duration_statement = 0`
`29`	`37`	`log_statement = 'none'`
`30`	`38`	`log_timezone = 'Etc/UTC'`

Comments

(0)