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
做了个notion上的调查笔记模板,自用之余分享一下
链接:https://tough-cicada-901.notion.site/4529edfef1474d90b4fc839a107e5848
如何导入模板:打开链接后点击右上角Duplicate
如何使用模板:把模板拖到调查笔记页面即可
本模板分五个标签,分别是时间轴,事件,人物,线索,物品,其中事件与人物有设置好的次级模板(见P2,3)
临时制作,比较简陋,有好思路欢迎和我分享
此外还有朋友帮忙制作的简易coc&dnd角色卡模板,因为是黑曜石自动生成,用起来需要自己修改,就不公开分享了,想要的话可以私聊
代码合好了,正在构建镜像...
https://drone.2heng.xin/mashirozx/mastodon/55
Gargron现在是直接给主分支打release tag了吗?以前release会有单独的分支,最新的功能暂时还不会合进去,所以以前的release很少会发版后遇到严重bug需要hotfix,现在这样就是偷懒了呀
#Mastodon 3.5.3 has just been released with multiple security fixes, as well as a couple cool improvements!
https://github.com/mastodon/mastodon/releases/tag/v3.5.3
A 3.4.8 backport is available for those who haven't made the jump to 3.5 yet.
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号
//转发自: @差评君: 这名“业余”程序员,曾用50张1080ti对抗癌症【差评君】
看完他的故事,我对AI治疗癌症满怀希望
https://api.2heng.xin/bilibili/og.php?av=426952626&high_quality=1&danmaku=0
https://t.bilibili.com/664593494147334169
Chinese 🇨🇳 / Dictatorial Admin / Mastodon Code Contributor / 摸鱼技术布道师
Steam: https://steamcommunity.com/id/MashiroBest
Epic: https://store.epicgames.com/en-US/u/d211c824cbd94aaeba898db6bb823ff7
原批交流群:966322309