Just looking for understanding/ideas.
I assume when people use dashboards they are not being queried every second for updating but maybe every minute? Are there any tools that work good on top of postgres? (I see in the stock market (though I am looking at/for production data) they seem to use tools that frequently update their dashboards. What is a realistic timeframe to expect query updates for a dashboard?
