Re: Log rotation

Поиск
Список
Период
Сортировка
От Fernando Nasser
Тема Re: Log rotation
Дата
Msg-id 4054875E.5050007@redhat.com
обсуждение исходный текст
Ответ на Re: Log rotation  (Lamar Owen <lowen@pari.edu>)
Список pgsql-hackers
Lamar Owen wrote:
> On Saturday 13 March 2004 01:00 pm, Fernando Nasser wrote:
> 
>>There are some applicatons which run in servers with very strict
>>response times and any syscall, network packet that can be saved counts.
> 
> 
> Ok, what about pipe overhead?  If we're gong to split hairs, let's split all 
> of them.  The design of the pipeline in this logrotator filter will have to 
> be such that minimal overhead occurs, because, at the real-time level, every 
> concurrent process also counts.
> 

Splitting hairs was not my intention :-)  But there is always something 
to gain or learn from a good debate...

What you say is true.  Nobody seems to consider that there si some 
overhead in piping as well.  Perhaps it is another (unproved?) belief 
that it will not be as significant as using a central syslog service.

> 
>>The number of generated messgaes.
> 
> 
>>Maybe that is an area that can be worked on, i.e. reducing log
>>verbosity.  Is 7.4.x much better than 7.3.x in that respect?
> 
> 
> There are several levels documented in postgresql.conf.  Try the terse level 
> and see what happens.

It used to be that if you lowered it too much you would get fewer 
messages but not enough information.  There is a tendency that this 
improves with time, I would guess.

There are cases where a problem is suspected and then users have to 
raise the log level in the hopes that it gives them some clue when the 
problem manifests itself (which sometimes, at least on a first instance, 
only happens in the production environment as is triggered by some weird 
usage pattern).


Best regards,
Fernando



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

Предыдущее
От: Fernando Nasser
Дата:
Сообщение: Re: Log rotation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Log rotation