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. |
||
|---|---|---|
| .. | ||
| adapters | ||
| migrations | ||
| utils | ||
| deno.json | ||
| DittoDB.ts | ||
| DittoPgMigrator.ts | ||
| DittoTables.ts | ||
| KyselyLogger.ts | ||
| mod.ts | ||