TechHacker Noonabout 4 hours ago
How Small Postgres Metadata Tables Quietly Throttle Your Largest Queries
8 min read
A 10,000-row device metadata table can silently slow time-series queries when Postgres uses stale statistics. The default autovacuum_analyze_scale_factor of 0.2 means 2,000 rows must change before a statistics refresh triggers. A table with rare inserts may show the planner a 600-row estimate, causing bad join plans.
Level
Hype check
Tap to vote and see what everyone thinks.
