Axiomancer
Changelog

May 11, 2026

Overwatch fixes pairwise encounter timeouts, resumes AIS H3 backfills, and moves heavy ingestion jobs to a dedicated worker.

May 11, 2026OverwatchFix

Hourly pairwise encounter extraction stops timing out

Roughly half of hourly pairwise encounter runs had been failing with a statement timeout on the densest 90-minute windows — the scan paginating through tens of thousands of AIS positions per window was scaling linearly with table size and tipping over past page 4. The extractor now pages forward through the primary-key index instead, so each step is a constant-time seek and the full hour completes well under the statement timeout. Encounter geometry — CPA, TCPA, range, closing speed, and COLREGS posteriors — resumes landing on schedule in the Risk and Investigations feeds, and backfill of the gap window is in progress.

May 11, 2026OverwatchFix

H3 spatial-index backfill on AIS positions resumes

The H3 spatial-index backfill on AIS positions had been silently retrying without progress for roughly 13 days as the batch size outgrew what the database could finish inside a single statement window, leaving a tail of older positions without their H3 cell assigned. The batch size has been tuned down so each pass clears the window cleanly, the cursor is advancing again, and spatial joins against density, ports, and chokepoint layers will reflect the full historical record once the backfill catches up.

May 11, 2026OverwatchUpdate

Heavy recurring jobs move onto a dedicated worker

Several heavy recurring jobs — per-port water-density refresh feeding hydrostatic cargo validation, temporal-motif scoring on pairwise encounters, weekly trade-flow aggregation, and the benchmark spoofing detector — now run on a dedicated persistent worker instead of sharing the database cron pool. The jobs continue to land on their existing cadences with a 5-minute heartbeat and graceful restart, so transient database pressure no longer skips a scheduled run. No configuration changes are required on your part.

On this page