共 6 篇文章 |
|
当在主服务器上运行DROP TABLE命令时,主服务器并不知道备用服务器上运行了哪些查询,因此它不会等待备用服务器上的任何此类查询。它允许备用服务器上的查询能够可靠地完成,但是将导致主服务器上的膨胀现象,当备用服务器上的查询长时间不结束时,此膨胀现象尤为明显。2)提高max_standby_archive_delay或者max_standby_streaming_delay参数,... 阅798 转2 评0 公众公开 19-07-18 13:25 |
pgpool需要的数据库连接数=num_init_children*max_pool;num_init_children*max_pool<max_connections-superuser_reserved_connections.当需要pgpool支持更多的并发时,需要更改num_init_children参数,同时要检查下num_init_children*max_pool是否超过了max_connections-superuser_reserved_connections,如果超过了,可将max_connections... 阅591 转0 评0 公众公开 19-05-21 15:25 |
查看pg正在执行的sql,并杀掉长时间等待进程查看执行的sql:SELECT procpid,start,now() - start AS lap,current_query FROM (SELECT backendid,pg_stat_get_backend_pid(S.backendid) AS procpid,pg_stat_get_backend_activity_start(S.backendid) AS start,pg_stat_get_backend_activity(S.backendid) AS current_query FROM (SELECT pg_stat... 阅2102 转11 评0 公众公开 18-10-08 15:33 |
max_standby_streaming_delay (integer) When Hot Standby is active, this parameter determines how long thestandby server should wait before canceling standby queries thatconflict with about-to-be-applied WAL entries, as described inSection 25.5.2. max_standby_streaming_delay applies when WAL datais being received ... 阅528 转1 评0 公众公开 13-12-03 15:31 |
FATAL: could not receive data from WAL stream.FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 0000000100000000000000XX has already been removed.这样,如果master端的通讯比较繁忙,可能来不及应答,这样就可能发生 FATAL: could not receive data from WAL stream: could not receive data from serve... 阅1883 转1 评0 公众公开 13-10-28 14:50 |