how to measure wal_buffer usage

Поиск
Список
Период
Сортировка
От Lonni J Friedman
Тема how to measure wal_buffer usage
Дата
Msg-id CAP=oouEiQonSexM2Mm6OfF6hRNJrRRQHkvTsEipc47K=atKSfw@mail.gmail.com
обсуждение исходный текст
Ответы Re: how to measure wal_buffer usage  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список pgsql-general
After reading this interesting article on shared_buffers and wal_buffers:
http://rhaas.blogspot.com/2012/03/tuning-sharedbuffers-and-walbuffers.html

it got me wondering if my settings were ideal.  Is there some way to
measure wal_buffer usage in real time, so that I could simply monitor
it for some period of time, and then come up with a way of determining
if the current setting is sufficient?

I tried googling, but every reference that I've found simply defaults
to the "trial & error" approach to performance tuning.

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

Предыдущее
От: Bret Stern
Дата:
Сообщение: Re: Backups
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Using copy with a file containing blank rows