finding out what's generating WALs

Поиск
Список
Период
Сортировка
От Chris Withers
Тема finding out what's generating WALs
Дата
Msg-id 86ae8f52-f0f3-2e74-c763-1af2553247e1@withers.org
обсуждение исходный текст
Ответы Re: finding out what's generating WALs
Список pgsql-general
Hi All,

With a 9.4 cluster, what's the best way to find out what's generating 
the most WAL?

I'm looking after a multi-tenant PG 9.4 cluster, and we've started 
getting alerts for the number of WALs on the server.
It'd be great to understand what's generating all that WAL and what's 
likely to be causing any problems.\

More generally, what's number of WALs is "too much"? check_postgres.pl 
when used in nagios format only appears to be able to alert on absolute 
thresholds, does this always make sense? What's a good threshold to 
alert on?

cheers,

Chris


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

Предыдущее
От: Mike Martin
Дата:
Сообщение: Code for getting particular day of week number from month
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Newly Created Source DB Table Not Reflecting into DestinationForeign Tables