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 по дате отправления: