HVR的两种refresh方式对比

没有特殊情况尽量用bulk，bulk方式相比row yb row方式会快很多。

 

以下是刷新同一张大表的时间对比：

row by row方式:
Table 'testtable' in location 'test' (199241477 rows) and location 'test1' (198948686 rows) differed by 292791 inserts (compression=99.8%). This row-wise refresh took36.99 minutes.


bulk方式:
Refreshed 'testtable' from location 'test' to location 'test2' (199241477 rows 228 wide compression=98.8%). This bulk refresh took15.76 minutes.