# Pastebin CINnmeJY
27c27,28
< # Memory units:  kB = kilobytes        Time units:  ms  = milliseconds
---
> # Memory units:  B  = bytes            Time units:  us  = microseconds
> #                kB = kilobytes                     ms  = milliseconds
59c60
< listen_addresses = '*'
---
> #listen_addresses = 'localhost'		# what IP address(es) to listen on;
76,77c77,78
< # - TCP Keepalives -
< # see "man 7 tcp" for details
---
> # - TCP settings -
> # see "man tcp" for details
84a86,87
> #tcp_user_timeout = 0			# TCP_USER_TIMEOUT, in milliseconds;
> 					# 0 selects the system default
93c96
< #krb_server_keyfile = ''
---
> #krb_server_keyfile = 'FILE:${sysconfdir}/krb5.keytab'
105a109,110
> #ssl_min_protocol_version = 'TLSv1.2'
> #ssl_max_protocol_version = ''
117c122
< shared_buffers = 16077MB			# min 128kB
---
> shared_buffers = 128MB			# min 128kB
126,127c131,133
< work_mem = 20579kB				# min 64kB
< maintenance_work_mem = 2047MB		# min 1MB
---
> #work_mem = 4MB				# min 64kB
> #hash_mem_multiplier = 1.0		# 1-1000.0 multiplier on hash table work_mem
> #maintenance_work_mem = 64MB		# min 1MB
128a135
> #logical_decoding_work_mem = 64MB	# min 64kB
129a137,142
> #shared_memory_type = mmap		# the default is the first option
> 					# supported by the operating system:
> 					#   mmap
> 					#   sysv
> 					#   windows
> 					# (change requires restart)
136d148
< 					# use none to disable dynamic shared memory
142c154
< 					# in kB, or -1 for no limit
---
> 					# in kilobytes, or -1 for no limit
146c158
< #max_files_per_process = 1000		# min 25
---
> #max_files_per_process = 1000		# min 64
151c163
< #vacuum_cost_delay = 0			# 0-100 milliseconds
---
> #vacuum_cost_delay = 0			# 0-100 milliseconds (0 disables)
166,167c178,180
< effective_io_concurrency = 200		# 1-1000; 0 disables prefetching
< max_worker_processes = 19		# (change requires restart)
---
> #effective_io_concurrency = 1		# 1-1000; 0 disables prefetching
> #maintenance_io_concurrency = 10	# 1-1000; 0 disables prefetching
> #max_worker_processes = 8		# (change requires restart)
169c182
< max_parallel_workers_per_gather = 4	# taken from max_parallel_workers
---
> #max_parallel_workers_per_gather = 2	# taken from max_parallel_workers
171c184
< max_parallel_workers = 8		# maximum number of max_worker_processes that
---
> #max_parallel_workers = 8		# maximum number of max_worker_processes that
194c207
< 					#   fdatasync (default on Linux)
---
> 					#   fdatasync (default on Linux and FreeBSD)
202c215,217
< wal_buffers = 16MB			# min 32kB, -1 sets based on shared_buffers
---
> #wal_init_zero = on			# zero-fill new WAL files
> #wal_recycle = on			# recycle WAL files
> #wal_buffers = -1			# min 32kB, -1 sets based on shared_buffers
205a221
> #wal_skip_threshold = 2MB
214,215c230,231
< min_wal_size = 512MB
< checkpoint_completion_target = 0.9	# checkpoint target duration, 0.0 - 1.0
---
> min_wal_size = 80MB
> #checkpoint_completion_target = 0.5	# checkpoint target duration, 0.0 - 1.0
229a246,281
> # - Archive Recovery -
> 
> # These are only used in recovery mode.
> 
> #restore_command = ''		# command to use to restore an archived logfile segment
> 				# placeholders: %p = path of file to restore
> 				#               %f = file name only
> 				# e.g. 'cp /mnt/server/archivedir/%f %p'
> 				# (change requires restart)
> #archive_cleanup_command = ''	# command to execute at every restartpoint
> #recovery_end_command = ''	# command to execute at completion of recovery
> 
> # - Recovery Target -
> 
> # Set these only when performing a targeted recovery.
> 
> #recovery_target = ''		# 'immediate' to end recovery as soon as a
>                                 # consistent state is reached
> 				# (change requires restart)
> #recovery_target_name = ''	# the named restore point to which recovery will proceed
> 				# (change requires restart)
> #recovery_target_time = ''	# the time stamp up to which recovery will proceed
> 				# (change requires restart)
> #recovery_target_xid = ''	# the transaction ID up to which recovery will proceed
> 				# (change requires restart)
> #recovery_target_lsn = ''	# the WAL LSN up to which recovery will proceed
> 				# (change requires restart)
> #recovery_target_inclusive = on # Specifies whether to stop:
> 				# just after the specified recovery target (on)
> 				# just before the recovery target (off)
> 				# (change requires restart)
> #recovery_target_timeline = 'latest'	# 'current', 'latest', or timeline ID
> 				# (change requires restart)
> #recovery_target_action = 'pause'	# 'pause', 'promote', 'shutdown'
> 				# (change requires restart)
> 
241c293,294
< #wal_keep_segments = 0		# in logfile segments; 0 disables
---
> #wal_keep_size = 0		# in megabytes; 0 disables
> #max_slot_wal_keep_size = -1	# in megabytes; -1 disables
262a316,318
> #primary_conninfo = ''			# connection string to sending server
> #primary_slot_name = ''			# replication slot on sending server
> #promote_trigger_file = ''		# file name whose presence ends recovery
270a327,328
> #wal_receiver_create_temp_slot = off	# create temp slot if primary_slot_name
> 					# is not set
279a338
> #recovery_min_apply_delay = 0		# minimum delay for applying changes during recovery
306a366
> #enable_incremental_sort = on
316c376
< random_page_cost = 1.1			# same scale as above
---
> #random_page_cost = 4.0			# same scale as above
334c394
< effective_cache_size = 48233MB
---
> #effective_cache_size = 4GB
348c408
< default_statistics_target = 500	# range 1-10000
---
> #default_statistics_target = 100	# range 1-10000
355c415,417
< #jit = off				# allow JIT compilation
---
> #jit = on				# allow JIT compilation
> #plan_cache_mode = auto			# auto, force_generic_plan or
> 					# force_custom_plan
440a503,516
> #log_min_duration_sample = -1		# -1 is disabled, 0 logs a sample of statements
> 					# and their durations, > 0 logs only a sample of
> 					# statements running at least this number
> 					# of milliseconds;
> 					# sample fraction is determined by log_statement_sample_rate
> 
> #log_statement_sample_rate = 1.0	# fraction of logged statements exceeding
> 					# log_min_duration_sample to be logged;
> 					# 1.0 logs all such statements, 0.0 never logs
> 
> 
> #log_transaction_sample_rate = 0.0	# fraction of transactions whose statements
> 					# are logged regardless of their duration; 1.0 logs all
> 					# statements from all transactions, 0.0 never logs
459a536
> 					#   %b = backend type
475a553,558
> #log_parameter_max_length = -1		# when logging statements, limit logged
> 					# bind-parameter values to N bytes;
> 					# -1 means print in full, 0 disables
> #log_parameter_max_length_on_error = 0	# when logging an error, limit logged
> 					# bind-parameter values to N bytes;
> 					# -1 means print in full, 0 disables
481c564
< log_timezone = 'UTC'
---
> log_timezone = 'Etc/UTC'
524c607
< autovacuum_max_workers = 10		# max number of autovacuum subprocesses
---
> #autovacuum_max_workers = 3		# max number of autovacuum subprocesses
526c609
< autovacuum_naptime = 10		# time between autovacuum runs
---
> #autovacuum_naptime = 1min		# time between autovacuum runs
528a612,614
> #autovacuum_vacuum_insert_threshold = 1000	# min number of row inserts
> 					# before vacuum; -1 disables insert
> 					# vacuums
531a618,619
> #autovacuum_vacuum_insert_scale_factor = 0.2	# fraction of inserts over table
> 					# size before insert vacuum
538c626
< #autovacuum_vacuum_cost_delay = 20ms	# default vacuum cost delay for
---
> #autovacuum_vacuum_cost_delay = 2ms	# default vacuum cost delay for
566a655
> #default_table_access_method = 'heap'
592c681
< timezone = 'UTC'
---
> timezone = 'Etc/UTC'
600c689,690
< #extra_float_digits = 0			# min -15, max 3
---
> #extra_float_digits = 1			# min -15, max 3; any value >0 actually
> 					# selects precise output mode
605c695
< lc_messages = 'en_US.utf8'			# locale for system error message
---
> lc_messages = 'en_US.UTF8'			# locale for system error message
607,609c697,699
< lc_monetary = 'en_US.utf8'			# locale for monetary formatting
< lc_numeric = 'en_US.utf8'			# locale for number formatting
< lc_time = 'en_US.utf8'				# locale for time formatting
---
> lc_monetary = 'en_US.UTF8'			# locale for monetary formatting
> lc_numeric = 'en_US.UTF8'			# locale for number formatting
> lc_time = 'en_US.UTF8'				# locale for time formatting
616c706
< shared_preload_libraries = 'timescaledb'	# (change requires restart)
---
> #shared_preload_libraries = ''	# (change requires restart)
623a714,715
> #extension_destdir = ''			# prepend path when loading extensions
> 					# and shared objects (added by Debian)
631c723
< max_locks_per_transaction = 512		# min 10
---
> #max_locks_per_transaction = 64		# min 10
649d740
< #default_with_oids = off
692,695c783
< timescaledb.telemetry_level=basic
< timescaledb.max_background_workers = 8
< timescaledb.last_tuned = '2022-03-08T14:04:32Z'
< timescaledb.last_tuned_version = '0.11.0'
---
> shared_preload_libraries = 'timescaledb'