2016年関西地区PostgreSQL勉強会 調査資料 [公開用]
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
RDSパラメータ(mini)RDSパラメータ(mid)インスタンス比較デフォルト値デフォルト比較
2
allow_system_table_modsoffoff-off-
3
application_name|psql差分psql差分
4
archive_command
/etc/rds/dbbin/pgscripts/rds_wal_archive
/etc/rds/dbbin/pgscripts/rds_wal_archive
-(disabled)差分
5
archive_modeonon-off差分
6
archive_timeout5min5min-0差分
7
array_nullsonon-on-
8
authentication_timeout1min1min-1min-
9
autovacuumonon-on-
10
autovacuum_analyze_scale_factor0.050.05-0.1差分
11
autovacuum_analyze_threshold5050-50-
12
autovacuum_freeze_max_age200000000200000000-200000000-
13
autovacuum_max_workers33-3-
14
autovacuum_multixact_freeze_max_age
400000000400000000-400000000-
15
autovacuum_naptime30s30s-1min差分
16
autovacuum_vacuum_cost_delay20ms20ms-20ms-
17
autovacuum_vacuum_cost_limit-1-1--1-
18
autovacuum_vacuum_scale_factor0.10.1-0.2差分
19
autovacuum_vacuum_threshold5050-50-
20
autovacuum_work_mem-1-1--1-
21
backslash_quotesafe_encodingsafe_encoding-safe_encoding-
22
bgwriter_delay200ms200ms-200ms-
23
bgwriter_lru_maxpages100100-100-
24
bgwriter_lru_multiplier22-2-
25
block_size81928192-8192-
26
bonjouroffoff-off-
27
bonjour_name||-|-
28
bytea_outputhexhex-hex-
29
check_function_bodiesonon-on-
30
checkpoint_completion_target0.90.9-0.5差分
31
checkpoint_timeout5min5min-5min-
32
checkpoint_warning30s30s-30s-
33
client_encodingUTF8UTF8-UTF8-
34
client_min_messagesnoticenotice-notice-
35
cluster_name||-|-
36
commit_delay00-0-
37
commit_siblings55-5-
38
config_file差分
/var/lib/pgsql/9.5/data/postgresql.conf
差分
39
constraint_exclusionpartitionpartition-partition-
40
cpu_index_tuple_cost0.0050.005-0.005-
41
cpu_operator_cost0.00250.0025-0.0025-
42
cpu_tuple_cost0.010.01-0.01-
43
cursor_tuple_fraction0.10.1-0.1-
44
data_checksumsonon-off差分
45
data_directory差分
/var/lib/pgsql/9.5/data
差分
46
DateStyleISO,ISO,-ISO,-
47
db_user_namespaceoffoff-off-
48
deadlock_timeout1s1s-1s-
49
debug_assertionsoffoff-off-
50
debug_pretty_printonon-on-
51
debug_print_parseoffoff-off-
52
debug_print_planoffoff-off-
53
debug_print_rewrittenoffoff-off-
54
default_statistics_target100100-100-
55
default_tablespace||-|-
56
default_text_search_config
pg_catalog.simple
pg_catalog.simple-
pg_catalog.english
差分
57
default_transaction_deferrableoffoff-off-
58
default_transaction_isolationreadread-read-
59
default_transaction_read_onlyoffoff-off-
60
default_with_oidsoffoff-off-
61
dynamic_library_path差分$libdir差分
62
dynamic_shared_memory_typeposixposix-posix-
63
effective_cache_size407688kB1922960kB差分4GB差分
64
effective_io_concurrency11-1-
65
enable_bitmapscanonon-on-
66
enable_hashaggonon-on-
67
enable_hashjoinonon-on-
68
enable_indexonlyscanonon-on-
69
enable_indexscanonon-on-
70
enable_materialonon-on-
71
enable_mergejoinonon-on-
72
enable_nestlooponon-on-
73
enable_seqscanonon-on-
74
enable_sortonon-on-
75
enable_tidscanonon-on-
76
escape_string_warningonon-on-
77
event_sourcePostgreSQLPostgreSQL-PostgreSQL-
78
exit_on_erroroffoff-off-
79
external_pid_file差分|差分
80
extra_float_digits00-0-
81
from_collapse_limit88-8-
82
fsynconon-on-
83
full_page_writesonon-on-
84
geqoonon-on-
85
geqo_effort55-5-
86
geqo_generations00-0-
87
geqo_pool_size00-0-
88
geqo_seed00-0-
89
geqo_selection_bias22-2-
90
geqo_threshold1212-12-
91
gin_fuzzy_search_limit00-0-
92
gin_pending_list_limit4MB4MB-4MB-
93
hba_file差分
/var/lib/pgsql/9.5/data/pg_hba.conf
差分
94
hot_standbyoffoff-off-
95
hot_standby_feedbackoffoff-off-
96
huge_pagestrytry-try-
97
ident_file差分
/var/lib/pgsql/9.5/data/pg_ident.conf
差分
98
ignore_checksum_failureoffoff-off-
99
ignore_system_indexesoffoff-off-
100
integer_datetimesonon-on-
Loading...
 
 
 
PostgreSQL9.5.2調査シート
MySQL5.6調査シート