Re: postgresql transaction id monitoring with nagios

[Vivek Khera <vivek@xxxxxxxxx>]

On May 2, 2006, at 3:03 PM, Alvaro Herrera wrote:

> > 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.  (Wow, who wouldn't want a person-wide  
> vacuum if
> it did the same thing ...)

and what exactly is "vacuumdb -a -z" doing besides a database wide  
vacuum?

Attachment: smime.p7s
Description: S/MIME cryptographic signature