-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathpg-settings.txt
366 lines (365 loc) · 23.2 KB
/
pg-settings.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
name | setting
----------------------------------------------------------+---------------------------------------------------------------------------------------------------------
allow_in_place_tablespaces | off
allow_system_table_mods | off
application_name | psql
archive_cleanup_command |
archive_command | /utils/replication_log_processor -disable_log_to_disk -action=archive -file_name=%f -local_file_path=%p
archive_mode | on
archive_timeout | 0
array_nulls | on
authentication_timeout | 60
autovacuum | on
autovacuum_analyze_scale_factor | 0.1
autovacuum_analyze_threshold | 50
autovacuum_freeze_max_age | 200000000
autovacuum_max_workers | 3
autovacuum_multixact_freeze_max_age | 400000000
autovacuum_naptime | 60
autovacuum_vacuum_cost_delay | 2
autovacuum_vacuum_cost_limit | -1
autovacuum_vacuum_insert_scale_factor | 0.2
autovacuum_vacuum_insert_threshold | 1000
autovacuum_vacuum_scale_factor | 0.4
autovacuum_vacuum_threshold | 50
autovacuum_work_mem | -1
backend_flush_after | 0
backslash_quote | safe_encoding
backtrace_functions |
bgwriter_delay | 50
bgwriter_flush_after | 64
bgwriter_lru_maxpages | 200
bgwriter_lru_multiplier | 2
block_size | 8192
bonjour | off
bonjour_name |
bytea_output | hex
check_function_bodies | on
checkpoint_completion_target | 0.9
checkpoint_flush_after | 32
checkpoint_timeout | 3600
checkpoint_warning | 30
client_connection_check_interval | 0
client_encoding | UTF8
client_min_messages | notice
cloudsql.enable_anon | off
cloudsql.enable_auto_explain | off
cloudsql.enable_maintenance_mode | off
cloudsql.enable_pg_bigm | off
cloudsql.enable_pg_cron | off
cloudsql.enable_pg_hint_plan | off
cloudsql.enable_pg_wait_sampling | off
cloudsql.enable_pgaudit | off
cloudsql.enable_pglogical | off
cloudsql.enable_stacktrace | off
cloudsql.extension_maintenance | off
cloudsql.logical_decoding | off
cloudsql.max_free_memory | -1
cloudsql.pg_authid_select_role |
cloudsql.pg_shadow_select_role |
cluster_name |
commit_delay | 0
commit_siblings | 5
compute_query_id | auto
constraint_exclusion | partition
cpu_index_tuple_cost | 0.005
cpu_operator_cost | 0.0025
cpu_tuple_cost | 0.01
cursor_tuple_fraction | 0.1
data_checksums | on
data_directory_mode | 0700
data_sync_retry | off
DateStyle | ISO, MDY
db_user_namespace | off
deadlock_timeout | 1000
debug_assertions | off
debug_discard_caches | 0
debug_pretty_print | on
debug_print_parse | off
debug_print_plan | off
debug_print_rewritten | off
default_statistics_target | 100
default_table_access_method | heap
default_tablespace |
default_text_search_config | pg_catalog.english
default_toast_compression | pglz
default_transaction_deferrable | off
default_transaction_isolation | serializable
default_transaction_read_only | off
dynamic_shared_memory_type | posix
effective_cache_size | 250000
effective_io_concurrency | 1
enable_async_append | on
enable_bitmapscan | on
enable_gathermerge | on
enable_hashagg | on
enable_hashjoin | on
enable_incremental_sort | on
enable_indexonlyscan | on
enable_indexscan | on
enable_material | on
enable_memoize | on
enable_mergejoin | on
enable_nestloop | on
enable_parallel_append | on
enable_parallel_hash | on
enable_partition_pruning | on
enable_partitionwise_aggregate | off
enable_partitionwise_join | off
enable_seqscan | on
enable_sort | on
enable_tidscan | on
escape_string_warning | on
event_source | PostgreSQL
exit_on_error | off
extra_float_digits | 1
force_parallel_mode | off
from_collapse_limit | 8
fsync | on
full_page_writes | on
geqo | on
geqo_effort | 5
geqo_generations | 0
geqo_pool_size | 0
geqo_seed | 0
geqo_selection_bias | 2
geqo_threshold | 12
gin_fuzzy_search_limit | 0
gin_pending_list_limit | 4096
google_insights.allocate_memory | on
google_insights.enabled | on
google_insights.max_aggregated_stats_entry | 5000
google_insights.max_per_database_statements_counts | 100
google_insights.max_query_length | 1024
google_insights.max_query_stats_entry | 5000
google_insights.max_tag_stats_entry | 5000
google_insights.num_query_plans_per_minute | 5
google_insights.num_trace_context_query_plans_per_minute | 5
google_insights.skip_acquired_sample_lock | on
google_insights.trace_buffer_size_in_kb | 1024
google_insights.track | on
google_insights.track_client_address | on
google_insights.track_comment | on
google_insights.track_internal_metrics | on
google_insights.track_new_connection_stats | on
google_insights.track_statements_executed_count | on
hash_mem_multiplier | 1
hot_standby | on
hot_standby_feedback | off
huge_page_size | 0
huge_pages | try
idle_in_transaction_session_timeout | 0
idle_session_timeout | 0
ignore_checksum_failure | off
ignore_invalid_pages | off
ignore_system_indexes | off
in_hot_standby | off
integer_datetimes | on
IntervalStyle | postgres
jit | on
jit_above_cost | 100000
jit_debugging_support | off
jit_dump_bitcode | off
jit_expressions | on
jit_inline_above_cost | 500000
jit_optimize_above_cost | 500000
jit_profiling_support | off
jit_tuple_deforming | on
join_collapse_limit | 8
krb_caseins_users | off
lc_collate | en_US.UTF8
lc_ctype | en_US.UTF8
lc_messages | en_US.UTF8
lc_monetary | en_US.UTF8
lc_numeric | en_US.UTF8
lc_time | en_US.UTF8
listen_addresses | *
lo_compat_privileges | off
local_preload_libraries |
lock_timeout | 0
log_autovacuum_min_duration | 0
log_checkpoints | on
log_connections | off
log_destination | stderr
log_disconnections | off
log_duration | off
log_error_verbosity | default
log_executor_stats | off
log_file_mode | 0600
log_hostname | off
log_line_prefix | %m [%p]: [%l-1] db=%d,user=%u
log_lock_waits | off
log_min_duration_sample | -1
log_min_duration_statement | -1
log_min_error_statement | error
log_min_messages | warning
log_parameter_max_length | -1
log_parameter_max_length_on_error | 0
log_parser_stats | off
log_planner_stats | off
log_recovery_conflict_waits | off
log_replication_commands | off
log_rotation_age | 0
log_rotation_size | 0
log_statement | none
log_statement_sample_rate | 1
log_statement_stats | off
log_temp_files | 0
log_timezone | UTC
log_transaction_sample_rate | 0
log_truncate_on_rotation | off
logging_collector | off
logical_decoding_work_mem | 65536
maintenance_io_concurrency | 10
maintenance_work_mem | 65536
max_connections | 200
max_files_per_process | 1000
max_function_args | 100
max_identifier_length | 63
max_index_keys | 32
max_locks_per_transaction | 128
max_logical_replication_workers | 4
max_parallel_maintenance_workers | 2
max_parallel_workers | 8
max_parallel_workers_per_gather | 2
max_pred_locks_per_page | 2
max_pred_locks_per_relation | -2
max_pred_locks_per_transaction | 128
max_prepared_transactions | 0
max_replication_slots | 10
max_slot_wal_keep_size | -1
max_stack_depth | 2048
max_standby_archive_delay | 30000
max_standby_streaming_delay | 30000
max_sync_workers_per_subscription | 2
max_wal_senders | 10
max_wal_size | 100000
max_worker_processes | 8
min_dynamic_shared_memory | 0
min_parallel_index_scan_size | 64
min_parallel_table_scan_size | 1024
min_wal_size | 1000
old_snapshot_threshold | -1
parallel_leader_participation | on
parallel_setup_cost | 1000
parallel_tuple_cost | 0.1
password_encryption | scram-sha-256
pg_stat_statements.max | 5000
pg_stat_statements.save | on
pg_stat_statements.track | top
pg_stat_statements.track_planning | off
pg_stat_statements.track_utility | on
plan_cache_mode | auto
port | 5432
post_auth_delay | 0
pre_auth_delay | 0
primary_slot_name |
promote_trigger_file |
quote_all_identifiers | off
random_page_cost | 1
recovery_end_command |
recovery_init_sync_method | fsync
recovery_min_apply_delay | 0
recovery_target |
recovery_target_action | pause
recovery_target_inclusive | on
recovery_target_lsn |
recovery_target_name |
recovery_target_time |
recovery_target_timeline | latest
recovery_target_xid |
remove_temp_files_after_crash | on
restart_after_crash | on
restore_command |
row_security | on
search_path | "$user", public
segment_size | 131072
seq_page_cost | 1
server_encoding | UTF8
server_version | 14.5
server_version_num | 140005
session_replication_role | origin
shared_buffers | 156928
shared_memory_type | mmap
ssl | on
ssl_ca_file | root.crt
ssl_cert_file | server.crt
ssl_crl_dir |
ssl_crl_file |
ssl_key_file | server.key
ssl_library | OpenSSL
ssl_passphrase_command_supports_reload | off
ssl_prefer_server_ciphers | on
standard_conforming_strings | on
statement_timeout | 0
superuser_reserved_connections | 3
synchronize_seqscans | on
synchronous_commit | on
synchronous_standby_names |
syslog_facility | local0
syslog_ident | postgres
syslog_sequence_numbers | on
syslog_split_messages | on
tcp_keepalives_count | 5
tcp_keepalives_idle | 60
tcp_keepalives_interval | 60
tcp_user_timeout | 0
temp_buffers | 1024
temp_file_limit | 96907141
temp_tablespaces |
TimeZone | UTC
timezone_abbreviations | Default
trace_notify | off
trace_recovery_messages | log
trace_sort | off
track_activities | on
track_activity_query_size | 1024
track_commit_timestamp | off
track_counts | on
track_functions | none
track_io_timing | on
track_lockwait_timing | on
track_wal_io_timing | off
transaction_deferrable | off
transaction_isolation | serializable
transaction_read_only | off
transform_null_equals | off
unix_socket_group |
unix_socket_permissions | 0777
update_process_title | on
vacuum_cost_delay | 0
vacuum_cost_limit | 200
vacuum_cost_page_dirty | 20
vacuum_cost_page_hit | 1
vacuum_cost_page_miss | 2
vacuum_defer_cleanup_age | 0
vacuum_failsafe_age | 1600000000
vacuum_freeze_min_age | 50000000
vacuum_freeze_table_age | 150000000
vacuum_multixact_failsafe_age | 1600000000
vacuum_multixact_freeze_min_age | 5000000
vacuum_multixact_freeze_table_age | 150000000
wal_block_size | 8192
wal_buffers | 2048
wal_compression | on
wal_consistency_checking |
wal_init_zero | on
wal_keep_size | 0
wal_level | replica
wal_log_hints | off
wal_receiver_create_temp_slot | off
wal_receiver_status_interval | 10
wal_receiver_timeout | 60000
wal_recycle | on
wal_retrieve_retry_interval | 5000
wal_segment_size | 16777216
wal_sender_timeout | 60000
wal_skip_threshold | 2048
wal_sync_method | fdatasync
wal_writer_delay | 200
wal_writer_flush_after | 128
work_mem | 4096
xmlbinary | base64
xmloption | content
zero_damaged_pages | off
(362 rows)