Re: postgresql transaction id monitoring with nagios - Mailing list pgsql-performance

From Vivek Khera
Subject Re: postgresql transaction id monitoring with nagios
Date
Msg-id A375C6D5-B7CF-484D-A24A-053462B1FC6D@khera.org
Whole thread Raw
In response to Re: postgresql transaction id monitoring with nagios  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: postgresql transaction id monitoring with nagios
Next
From: "Mark Liberman"
Date:
Subject: Re: Why is plan (and performance) different on partitioned table?