Design a database architecture for a large-scale video streaming platform supporting 100M+ daily active users. Your design should address high-frequency write ingestion for user watch progress, low-latency content metadata retrieval, and strong consistency for billing and subscriptions. Discuss how you would partition and shard data, handle write spikes, leverage caching, and ensure high availability across regions - using PostgreSQL-based technologies as the core storage layer.