fan_out_on_read complements materialized

fan out on readComplementsmaterialized view

Source: Pattern·Target: Pattern

Summary

Fan-out on read for high-follower accounts can be accelerated by maintaining a materialized view of each account's recent posts, reducing the per-follower fetch to a single indexed lookup per followed account.

Evidence

·fan_out_on_read lists materialized_view in related_patterns and recommends aggressively caching high-follower post lists (patterns/fan_out_on_read.yaml)
·materialized_view pre-computes a persisted result for the same expensive query run by many concurrent readers (patterns/materialized_view.yaml applicable_when)

Evidence grounding

Grounded, 2 supporting items

A celebrity's recent-posts list, read by all followers, is a materialized-view case.