Database Time-Series Data Handling

Handle time-series data for:

Data Type: [METRICS/EVENTS/IOT/FINANCIAL]
Database: [PostgreSQL/TimescaleDB/InfluxDB/MongoDB]
Data Characteristics:
- Write rate: [POINTS/SECOND]
- Retention: [HOW LONG TO KEEP]
- Query patterns: [AGGREGATIONS/RAW ACCESS]

Requirements:
- Downsampling: [YES/NO]
- Real-time queries: [YES/NO]
- Historical analysis: [YES/NO]

Please provide:
1. Schema design for time-series
2. Partitioning/chunking strategy
3. Efficient insert patterns
4. Common query patterns with examples
5. Data retention and cleanup
6. Aggregation and downsampling