PostgreSQL中的复制延迟

PostgreSQLPostgreSQL

PostgreSQL

PostgreSQLI/O

使

postgres=# SELECT pid,application_name,client_addr,client_hostname,state,sync_state,replay_lag FROM pg_stat_replication ;

 

:

postgres=# select pg_is_in_recovery(),pg_is_wal_replay_paused(), pg_last_wal_receive_lsn(), pg_last_wal_replay_lsn(), pg_last_xact_replay_timestamp();

:

:


I/O:I/OI/O

:

max_wal_senders

WALWALWAL

PostgreSQL

PostgreSQL:

:

使:

PostgreSQL:PostgreSQLwal_buffersmax_wal_senders


:

PostgreSQLpg_stat_replicationpg_wal_receiver_stats

 




PostgreSQL



使PostgreSQL

https://www.percona.com/blog/replication-lag-in-postgresql/

posted on 2023-04-20 11:18  张冲andy  阅读(214)  评论(0编辑  收藏  举报

导航