postgers的hot standby应该怎样配才能有效降低同步的延时?
目前的情况是,主从服务器不在一个机房,postgres的数据同步大约有一分钟的延时,但是在同样的机器上redis却能做到立即同步。
slot信息如图,下面是我的配置文件
# postgresql.conf
listen_addresses = '*'
max_connections = 100
shared_buffers = 128MB
dynamic_shared_memory_type = posix
wal_level = replica
max_wal_size = 1GB
min_wal_size = 80MB
max_wal_senders = 10
max_replication_slots = 10
hot_standby = on
wal_receiver_status_interval = 10s
hot_standby_feedback = on
wal_receiver_timeout = 60s
wal_retrieve_retry_interval = 5s
log_timezone = 'UTC'
datestyle = 'iso, mdy'
timezone = 'UTC'
lc_messages = 'en_US.utf8'
lc_monetary = 'en_US.utf8'
lc_numeric = 'en_US.utf8'
lc_time = 'en_US.utf8'
default_text_search_config = 'pg_catalog.english'
shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.track = all
RT Andy Boreham 安柏然
A World Without Humans.
I can’t verify, but this is supposedly the Apple store at IAPM in Xuhui District, Shanghai, just six weeks after people disappeared. Nature takes over fast!
上海市徐汇区淮海中路999号
还记得你何时加入 Twitter 吗?我知道!#我的Twitter周年纪念日 转眼十年过去了啊
Chinese 🇨🇳 / Dictatorial Admin / Mastodon Code Contributor / 摸鱼技术布道师
Steam: https://steamcommunity.com/id/MashiroBest
Epic: https://store.epicgames.com/en-US/u/d211c824cbd94aaeba898db6bb823ff7
原批交流群:966322309