How TimescaleDB helped us scale analytics and reporting

What this post added

This post details the adoption of TimescaleDB, a PostgreSQL extension, for the analytics and reporting needs of the Digital Experience Monitoring (DEX) product within the Zero Trust suite. It highlights the decision-making process, favoring simplicity and a 'daily driver' approach over the complexity of ClickHouse for initial MVP launch. The post explains the design of the configuration and analytics planes, the use of PostgreSQL for storing structured logs, and the optimization of multicolumn indexes for time-series data, showcasing a pragmatic approach to scaling analytics by leveraging familiar technologies and strategic use of extensions.