In case members of this channel find it useful, I wanted to share some work that Timescale has undertaken around the performance of Grafana with PostgreSQL. The blog article can be read here: Slow Grafana Performance? Learn How to Fix It Using Downsampling
We also have some free how-to videos in this YouTube playlist (link below). For those that may not know, TimescaleDB is packaged as an extension to PostgreSQL and is free-to-use-and-modify for anyone that self-manages their software either on-prem or in the public cloud.
Transparency: I work for Timescale, just hoping that these free resources may be of use to folks here.