Re: postgresql transaction id monitoring with nagios

From: Vivek Khera <vivek(at)khera(dot)org>
To: Pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: postgresql transaction id monitoring with nagios
Date: 2006-05-02 18:50:04
Message-ID: 628A837A-9718-46BB-85D7-8A63BBB1CA32@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On May 2, 2006, at 2:26 PM, Tony Wasson wrote:

> The script detects a wrap at 2 billion. It starts warning once one or
> more databases show an age over 1 billion transactions. It reports
> critical at 1.5B transactions. I hope everyone out there is vacuuming
> *all* databases often.

Something seems wrong... I just ran your script against my
development database server which is vacuumed daily and it said I was
53% of the way to 2B. Seemed strange to me, so I re-ran "vacuum -a -
z" to vacuum all databases (as superuser), reran the script and got
the same answer.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2006-05-02 19:03:40 Re: postgresql transaction id monitoring with nagios
Previous Message Mark Lewis 2006-05-02 18:49:15 Re: Slow restoration question