PMS 1.41.8.9834 (current beta) has the fix to reduce db bloat. It occurs when Optimize Database runs as a scheduled task which happens once/week (enable in settings → scheduled tasks).
- The process may take several hours to complete.
- Plex Media Server will be non-responsive while the optimization occurs (no streaming).
- The drive must have at least the size of the bloated db in working space. Move or delete backup db files if needed to free up space.
You can use WebTools-NG Butler Scheduled Tasks to start the scheduled task immediately.
WebTools-NG runs on PC/Mac/Linux (download). It does not have to run on the same system as Plex Media Server.