Why is the acceleration of adding indexes feature incompatible with PITR?

Issue: #38045

Currently, the acceleration of adding indexes feature is not compatible with PITR. When using index acceleration, you need to ensure that there are no PITR log backup tasks running in the background. Otherwise, unexpected behaviors might occur, including:

  • If you start a log backup task first, and then add an index. The adding index process is not accelerated even if index acceleration is enabled. But the index is added in a slow way.
  • If you start an index acceleration task first, and then start a log backup task. The log backup task returns an error. But the index acceleration is not affected.
  • If you start a log backup task and an index acceleration task at the same time, the two tasks might not be aware of each other. This might result in PITR failing to back up the newly added index.