mirror of
https://gitlab.com/soapbox-pub/ditto.git
synced 2025-12-06 03:19:46 +00:00
baa7968305
- 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. |
||
|---|---|---|
| .. | ||
| captcha | ||
| cashu | ||
| conf | ||
| db | ||
| ditto | ||
| lang | ||
| mastoapi | ||
| metrics | ||
| nip98 | ||
| policies | ||
| ratelimiter | ||
| transcode | ||
| translators | ||
| uploaders | ||