Heikki Linnakangas wrote: > Robert Treat wrote: >> 2) Can be graphed over time (using rrdtool and others) for trending >> checkpoint activity > > Hmm. You'd need the historical data to do that properly. In particular, > if two checkpoints happen between the polling interval, you'd miss that.
Yes, Munin and other tools collect the values over time to create the graph. It's not like "top" saves historical system load data either, yet the collector is able to present you with a graph. > log_checkpoints=on, in CSV output, seems like a better approach for that. It's not, because the tool would have a much harder time trolling the logs. CSV does not really make it much easier -- the DBA is still tasked with importing the thing after the current file is complete; and you don't have an up-to-date picture either. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-patches mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-patches
