On Mon, Oct 12, 2020 at 3:08 PM k.jami...@fujitsu.com <k.jami...@fujitsu.com> wrote: > > Hmm. When I repeated the performance measurement for non-recovery, > I got almost similar execution results for both master and patched. > > Execution Time (in seconds) > | s_b | master | patched | %reg | > |-------|--------|---------|--------| > | 128MB | 15.265 | 14.769 | -3.36% | > | 1GB | 14.808 | 14.618 | -1.30% | > | 20GB | 24.673 | 24.425 | -1.02% | > | 100GB | 74.298 | 74.813 | 0.69% | > > That is considering that I removed the recovery-related checks in the patch > and just > executed the commands on a standalone server. > - if (InRecovery && reln->smgr_cached_nblocks[forknum] != > InvalidBlockNumber) > + if (reln->smgr_cached_nblocks[forknum] != InvalidBlockNumber) >
Why so? Have you tried to investigate? Check if it takes an optimized path for the non-recovery case? -- With Regards, Amit Kapila.