benchmark icon indicating copy to clipboard operation
benchmark copied to clipboard

Add un-vacuumed deleted rows

Open georgewfraser opened this issue 8 years ago • 0 comments

Columnar data warehouses generally implement UPDATE by simply appending more rows and somehow flagging the "shadowed" rows as deleted. This benchmark would be more realistic if about 10% of the data in each table were deleted and replaced with similar data, so that there's some junk lying around that has to be skipped over by the query planner.

georgewfraser avatar Oct 11 '17 19:10 georgewfraser