From: Jamison, Kirk/ジャミソン カーク <k.jamison@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