Advanced Time-Series Database Schema for IoT Sensor Networks

Create a PostgreSQL schema optimized for storing and querying time-series sensor data from 10,000+ industrial IoT devices. Design a compression strategy that reduces storage by 70%, implements automatic data retention policies, and supports complex time-windowed aggregations. Include strategies for handling late-arriving data, detecting anomalies, and maintaining sub-millisecond query performance on historical datasets.