Performance Forecast
2ndQuadrant can extrapolate how performance of your database is likely to degrade over time, and suggest pro-active measures against this degradation.
Will a particular index soon grow to a point where it will be too large to keep a sufficient portion of its pages cached in memory to make the choice to use the index by the planner the right one? Is it time to start thinking about partitioning, and if not, when might it be? What sort of hardware upgrade should be considered to address the next bottleneck?
