Re: what server stats to track / monitor ?

From: Joshua Tolley <eggyknap(at)gmail(dot)com>
To: Alan McKay <alan(dot)mckay(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: what server stats to track / monitor ?
Date: 2009-06-13 20:23:09
Message-ID: 20090613202309.GM12253@eddie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Jun 12, 2009 at 04:40:12PM -0400, Alan McKay wrote:
> Any pointers for good reading material here? Other tips?

The manuals and/or source code for your software? Stories, case studies, and
reports from others in similar situations who have gone through problems?
Monitoring's job is to avert crises by letting you know things are going south
before they die completely. So you probably want to figure out ways in which
your setup is most likely to die, and make sure the critical points in that
equation are well-monitored, and you understand the monitoring. Provided you
stick with it long enough, you'll inevitably encounter a breakdown of some
kind or other, which will help you refine your idea of which points are
critical.

Apart from that, I find it's helpful to read about statistics and formal
testing, so you have some idea how confident you can be that the monitors are
accurate, that your decisions are justified, etc. But that's not everyone's
cup of tea...

- Josh / eggyknap

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Dan Langille 2009-06-13 22:36:43 Re: Censorship
Previous Message Alan McKay 2009-06-12 20:41:53 Re: what server stats to track / monitor ?