amutu@amutu.com wrote:
> we have a master and two streaming salve pg.we find One of the slave
> replay_location is far behand the other.
>
>
> both sent_location is BF1/921F6000;the write_location and flush_location is
> similar;but one of the server replay_location is BF1/9210DD10ï¼the oter is
> 6DE/D958E8.
>
> on the abnormal serverï¼top show that a postgres process replay the
> 00000001000006DE00000000 WALï¼and the process take up 100% usage of the cpu
> core.
Perhaps you can try to pg_xlogdump the offending pg_xlog file?
--
Ãlvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services