Re: PROPOSAL: tracking aggregated numbers from pg_stat_database

On Sat, 2013-04-06 at 21:51 +0200, Tomas Vondra wrote:
> This more or less works in stable environments, but once you start
> dropping databases (think of hosting with shared DB server) it gets
> unusable because after DROP DATABASE the database suddenly disappears
> from the sum.
>
> Therefore I do propose tracking the aggregated stats, similar to the
> pg_stat_bgwriter view.

It seems like this will open a can of worms. Maybe someone wants
aggregated stats for pg_stat_user_tables? Or maybe instead of the sum,
someone wants to track the average? etc. I don't think we should turn
the statistics collector into a poor man's data warehouse or statistics
engine. Couldn't you transfer the data to some other system for
long-term analysis? Maybe you could even use event triggers to have
DROP DATABASE do that automatically.