Unnecessary WAL archiving after failover
От | Fujii Masao |
---|---|
Тема | Unnecessary WAL archiving after failover |
Дата | |
Msg-id | CAHGQGwGQQLrODSVRb=HBTt6bj-dvz0NS=_jcNZRO9EMbUaLx0g@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Unnecessary WAL archiving after failover
|
Список | pgsql-hackers |
Hi, In streaming replication, after failover, new master might have lots of un-applied WAL files with old timeline ID. They are the WAL files which were recycled as a future ones when the server was running as a standby. Since they will never be used later, they don't need to be archived after failover. But since they have neither .ready nor .done file in archive_status, checkpoints after failover newly create .reacy files for them, and then finally they are archived. Which might cause disk I/O spike both in WAL and archive storage. To avoid the above problem, I think that un-applied WAL files with old timeline ID should be marked as already-archived and recycled immediately at the end of recovery. Thought? Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center
В списке pgsql-hackers по дате отправления: