TimescaleDB Continuous Aggregates: What I Got Wrong (and How to Fix It)

I thought continuous aggregates would solve my crypto data performance problems. They did, for about three weeks. Then the wheels came off, and I spent two months untangling the mess I'd made. If you're using TimescaleDB as your time-series database and thinking about continuous aggregates, read this first. I wish someone had warned me. The Setup I was storing OHLCV candlestick data (Open, High, Low, Close, Volume) for crypto pairs in TimescaleDB, a time-series database built on PostgreSQL, with