KamoCRM

Refresh planner statistics after the weekly GeoLite rebuild

PerformanceDaemonService
Shipped
10 ஆகஸ்ட், 2026 அன்று 6:33 PM UTC
Author
Kamo
Commit
638aa0a

YugabyteDB does not auto-analyze, and the staging+rename swap replaces geolite_blocks wholesale -- so after every Sunday sync the planner had no statistics for 5.8M rows. Running ANALYZE here keeps the IP lookup on the range index. With statistics the query measures 1.8ms; without the range index at all it was 8,814ms scanning every row. Failure is caught and logged rather than aborting the sync: stale statistics degrade planning, they do not break correctness.

All changes

Like what you see shipping?

All of it arrives in your workspace on its own. Start on the free plan and read this page again in a month.

Start Free ForeverView Pricing