一、操作系統(tǒng)
/etc/sysctl.conf 文件追加如下內(nèi)容：

成都創(chuàng)新互聯(lián)公司主營(yíng)響水網(wǎng)站建設(shè)的網(wǎng)絡(luò)公司,主營(yíng)網(wǎng)站建設(shè)方案,APP應(yīng)用開(kāi)發(fā),響水h5重慶小程序開(kāi)發(fā)搭建,響水網(wǎng)站營(yíng)銷(xiāo)推廣歡迎響水等地區(qū)企業(yè)咨詢

(sysctl -p 使配置生效)

kernel.shmmni = 4096
kernel.sem = 50100 64128000 50100 1280
fs.file-max = 7672460
net.core.rmem_default = 1048576
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.core.netdev_max_backlog = 10000
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65000
net.ipv4.tcp_tw_recycle = 1
net.ipv4.tcp_max_syn_backlog = 4096
net.ipv4.tcp_timestamps = 0
net.ipv4.tcp_keepalive_time=72
net.ipv4.tcp_keepalive_probes = 9
net.ipv4.tcp_keepalive_intvl = 7
vm.overcommit_memory = 0
vm.swappiness=0
vm.dirty_background_bytes=102400000
vm.dirty_bytes=102400000

/etc/security/limits.conf 文件追加如下內(nèi)容：

soft nofile 131072
hard nofile 131072
soft nproc 131072
hard nproc 131072
soft core unlimited
hard core unlimited
soft memlock 50000000
hard memlock 50000000
二、數(shù)據(jù)庫(kù)配置
listen_addresses = '*' # what IP address(es) to listen on;
port = 5432 # (change requires restart)
max_connections = 600 # (change requires restart)
unix_socket_directories = '.' # comma-separated list of directories
shared_buffers = 11581MB # min 128kB
maintenance_work_mem = 2048MB # min 1MB
dynamic_shared_memory_type = posix # the default is the first option
shared_preload_libraries = 'pg_stat_statements,pg_pathman' # (change requires restart)
vacuum_cost_limit = 10000 # 1-10000 credits
max_worker_processes = 8 # (change requires restart)
max_parallel_workers_per_gather = 5 # taken from max_worker_processes
wal_level = logical # minimal, replica, or logical
synchronous_commit = off # synchronization level;
wal_writer_delay = 500ms # 1-10000 milliseconds
max_wal_size = 4GB
min_wal_size = 1GB
checkpoint_completion_target = 0.9 # checkpoint target duration, 0.0 - 1.0
checkpoint_flush_after = 256kB # 0 disables,
archive_mode = on # enables archiving; off, on, or always
archive_command = '/bin/date' # command to use to archive a logfile segment
max_wal_senders = 13 # max number of walsender processes
wal_keep_segments = 256 # in logfile segments, 16MB each; 0 disables
hot_standby = on # "on" allows queries during recovery
random_page_cost = 4 # same scale as above
log_destination = 'csvlog' # Valid values are combinations of
logging_collector = on # Enable capturing of stderr and csvlog
log_directory = 'pg_log' # directory where log files are written,
log_filename = 'postgresql-%a.log' # log file name pattern,
log_truncate_on_rotation = on # If on, an existing log file with the
log_rotation_age = 1d # Automatic rotation of logfiles will
log_rotation_size = 10MB # Automatic rotation of logfiles will
log_min_duration_statement = 100ms # -1 is disabled, 0 logs all statements
log_timezone = 'PRC'
autovacuum_naptime = 30s # time between autovacuum runs
autovacuum_vacuum_scale_factor = 0.02 # fraction of table size before vacuum
temp_tablespaces = 'tbs_zabbix' # a list of tablespace names, '' uses
idle_in_transaction_session_timeout = 7200000 # in milliseconds, 0 is disabled
datestyle = 'iso, mdy'
timezone = 'PRC'
lc_messages = 'en_US.utf8' # locale for system error message
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
default_text_search_config = 'pg_catalog.english'
pg_stat_statements.max = 1000
pg_stat_statements.track = all
auth_delay.milliseconds = 5000

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無(wú)理由+7*72小時(shí)售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國(guó)服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡(jiǎn)單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢(shì)，專(zhuān)為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場(chǎng)景需求。

名稱(chēng)欄目：zabbix監(jiān)控?cái)?shù)據(jù)存放pg的數(shù)據(jù)庫(kù)配置-創(chuàng)新互聯(lián)
URL網(wǎng)址：http://aaarwkj.com/article8/hosip.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站設(shè)計(jì)公司、品牌網(wǎng)站建設(shè)、自適應(yīng)網(wǎng)站、品牌網(wǎng)站設(shè)計(jì)、網(wǎng)站策劃、電子商務(wù)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)