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

Reply via email to