catalog-indexer writes are timing out. Restarts clear them, but they recur within ~40 mins
- Root cause
- The catalog-indexer's postgres connection pool config was too low for the steady-state traffic.
- Ruled out
- Slow queries because pg_stat_statements p99 was flat and normal
- The Fix
- Raised pool max_size from 50 to 100.
- References
- investigation 9c4ba62aby Kevin Hou