Re: Log levels for checkpoint/bgwriter monitoring

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: Log levels for checkpoint/bgwriter monitoring
Дата
Msg-id Pine.GSO.4.64.0703052234440.16130@westnet.com
обсуждение исходный текст
Ответ на Re: Log levels for checkpoint/bgwriter monitoring  (Robert Treat <xzilla@users.sourceforge.net>)
Список pgsql-hackers
On Wed, 21 Feb 2007, Robert Treat wrote:

> My impression of this is that DBA's would typically want to run this for a
> short period of time to get thier systems tuned and then it pretty much
> becomes chatter.  Can you come up with an idea of what information DBA's need
> to know?

I am structing the log levels so that you can see all the events that are 
likely sources for extreme latency by using log level DEBUG1.  That level 
isn't too chatty and I've decided I can leave the server there forever if 
need by.  I've actually come with a much better interface to the 
background writer logging than the one I originally outlined, that I'll 
have ready for feedback in a few more days.  Now it dumps a nice summary 
report every time it completes a scan, rather than logging lower-level 
info.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD


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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Log levels for checkpoint/bgwriter monitoring
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bug: Buffer cache is not scan resistant