Re: postgresql transaction id monitoring with nagios

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: postgresql transaction id monitoring with nagios
Дата
Msg-id A375C6D5-B7CF-484D-A24A-053462B1FC6D@khera.org
обсуждение исходный текст
Ответ на Re: postgresql transaction id monitoring with nagios  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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?


Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: postgresql transaction id monitoring with nagios
Следующее
От: "Mark Liberman"
Дата:
Сообщение: Re: Why is plan (and performance) different on partitioned table?