- Limit materialized view to authors with followers_count > 0 and top 10k records
- Add proper indexes (search GIN, pubkey B-tree, followers_count DESC)
- Use CONCURRENTLY for non-blocking refreshes in cron job
- Reduces sorting overhead and memory usage during refresh
The original materialized view was expensive because it sorted all authors
regardless of follower count. This optimization reduces the dataset to a
manageable size while maintaining search functionality.
Fixes expensive query issue in top_authors materialized view.
