perf: optimize slow queries for trending/feed/community APIs (#368)

perf: autovacuum tuning and drop unused ix31 index (#367)

feat: add Redis cache invalidation hooks for indexer (#366)

ci: upgrade GitHub Actions and add latest-<short-sha> image tag (#365)

feat: hive_posts_cache_temp for hot queries (90-day window) (#364)

Fix cache layer todo (#363)

Add db pool size (#362)

feat: Add performance optimization indexes for ORDER BY DESC queries (#361)

Optimize follow api and cache tools (#360)

Optimize database query performance (#359)

fix cannot get self subscribe info (#358)

Optimize hive_posts_cache query with batch processing for large ID lists (#357)

Add caching to hive_feed_cache queries for performance optimization (#356)

Optimize hive_follows query: Replace LEFT JOIN with INNER JOIN (#355)

Optimize slow query child ids (#354)