From: Jamison, Kirk/ジャミソン カーク <k.jami...@fujitsu.com> > With the latest patches attached, and removing the recovery check in > smgrnblocks, I tested the performance of vacuum. > (3 trial runs, 3.5 GB db populated with 1000 tables) > > Execution Time (seconds) > | s_b | master | patched | %reg | > |-------|--------|---------|----------| > | 128MB | 15.265 | 15.260 | -0.03% | > | 1GB | 14.808 | 15.009 | 1.34% | > | 20GB | 24.673 | 11.681 | -111.22% | 100GB | 74.298 | 11.724 | > | -533.73% | > > These are good results and we can see the improvements for large shared > buffers, For small s_b, the performance is almost the same.
Very nice! I'll try to review the patch again soon. Regards Takayuki Tsunakawa