Re: Log rotation - Mailing list pgsql-hackers

From Fernando Nasser
Subject Re: Log rotation
Date
Msg-id 4054875E.5050007@redhat.com
Whole thread Raw
In response to Re: Log rotation  (Lamar Owen <lowen@pari.edu>)
List 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 by date:

Previous
From: Fernando Nasser
Date:
Subject: Re: Log rotation
Next
From: Tom Lane
Date:
Subject: Re: Log rotation