Tracking: Remote storage IOPS optimization

[hzxa21]

This issue tracks ideas on optimizing remote storage IOPS:

• perf(memory): use thread-local sequence-based memory eviction policy #16087
• Enable disk cache on dedicated ebs
  • https://github.com/risingwavelabs/risingwave-cloud/pull/7857
  • https://github.com/risingwavelabs/risingwave-cloud/pull/8203
• Monitor per state table read iops and block efficiency
• Unit based block prefetch for streaming state table feat(storage): unit level block fetch #17172
• Priority based block eviction considering operator/state table access pattern
• Limit per core remote storage IOPS
• CN local compaction
• Explore leveraging local disk as cache or maintain disk-based local version for read-heavy state table