compaction seems to cause more-than-expected cache invalidation and leads to poor performance

[lmatz]

When benchmarking q101 and also q103, it seems compaction has a large effect on stream processing,
i.e. the CPU usage/throughput when compaction + computation < the CPU usage/throughput when only computation.

Slack history: https://risingwave-labs.slack.com/archives/C03GTKX3C8G/p1676870159661769

the impact of block cache invalidation is bigger than what we saw in other queries

Feel free to reassign, thanks!

[lmatz]

cc: @Little-Wallace
Could you confirm if #8141 intends to fix this?
If so, let's close this one.

[lmatz]

reopen as there seems to be still large fluctuation, but may not be cache invalidation though