From: Alvaro Herrera <alvherre@commandprompt.com>
To: Vivek Khera <vivek@khera.org>
To: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: postgresql transaction id monitoring with nagios
Date: Tue, 2 May 2006 15:07:41 -0400
Message-ID: <20060502190741.GI15291@surnet.cl> (raw)
In-Reply-To: <20060502190340.GG15291@surnet.cl>
References: <6d8daee30605021126o7b44e255q552dcdc676c565bf@mail.gmail.com>
<628A837A-9718-46BB-85D7-8A63BBB1CA32@khera.org>
<20060502190340.GG15291@surnet.cl>
Alvaro Herrera wrote:
> Vivek Khera wrote:
> >
> > 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.
>
> That's right, because a database's age is only decremented in
> database-wide vacuums.
Forget it ... I must be blind ...
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvherre@commandprompt.com, vivek@khera.org
Subject: Re: postgresql transaction id monitoring with nagios
In-Reply-To: <20060502190741.GI15291@surnet.cl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox