Performance
Optimize Polling
Scenario
Poll Interval
Fetch Limit
Database Optimization
Add Indexes
CREATE INDEX idx_followers_status ON followers(status);
CREATE INDEX idx_followers_detected ON followers(detected_at);Archive Old Data
-- Move old launched followers to archive
INSERT INTO followers_archive SELECT * FROM followers
WHERE status = 'launched' AND launched_at < NOW() - INTERVAL '30 days';