Refresh planner statistics after the weekly GeoLite rebuild

PerformanceDaemonService
Shipped
August 10, 2026 at 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?

Every one of these updates lands in your workspace automatically. Start free and watch it grow week after week.

Start Free ForeverView Pricing