]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Prevent archive recovery from scanning non-existent WAL files.
authorFujii Masao <fujii@postgresql.org>
Tue, 7 Apr 2020 15:49:29 +0000 (00:49 +0900)
committerFujii Masao <fujii@postgresql.org>
Sat, 9 May 2020 03:00:27 +0000 (12:00 +0900)
commit683e0ef5530f449f0f913de579b4f7bcd31c91fd
tree9b5690a7f2100ecfaec3b66a67e3b98fc84a24e6
parent0507c07b5d5e30f85ce8e32653c7c2b14ceb8983
Prevent archive recovery from scanning non-existent WAL files.

Previously when there were multiple timelines listed in the history file
of the recovery target timeline, archive recovery searched all of them,
starting from the newest timeline to the oldest one, to find the segment
to read. That is, archive recovery had to continuously fail scanning
the segment until it reached the timeline that the segment belonged to.
These scans for non-existent segment could be harmful on the recovery
performance especially when archival area was located on the remote
storage and each scan could take a long time.

To address the issue, this commit changes archive recovery so that
it skips scanning the timeline that the segment to read doesn't belong to.

Per discussion, back-patch to all supported versions.

Author: Kyotaro Horiguchi, tweaked a bit by Fujii Masao
Reviewed-by: David Steele, Pavel Suderevsky, Grigory Smolkin
Discussion: https://postgr.es/m/16159-f5a34a3a04dc67e0@postgresql.org
Discussion: https://postgr.es/m/20200129.120222.1476610231001551715.horikyota.ntt@gmail.com
src/backend/access/transam/xlog.c