Re: rotatelog / logrotate with PostgreSQL - Mailing list pgsql-general

From Gaetano Mendola
Subject Re: rotatelog / logrotate with PostgreSQL
Date
Msg-id amuf7g$30a8$1@news.hub.org
Whole thread Raw
In response to Re: rotatelog / logrotate with PostgreSQL  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
"Martijn van Oosterhout" <kleptog@svana.org> wrote in message
news:20020926004757.GC5706@svana.org...
> On Wed, Sep 25, 2002 at 08:58:22AM -0600, scott.marlowe wrote:
> > Well, I've found the syslog facility to be noticeable slower than
> > rotatelogs with pgsql doing its own logging.  So that's why I do it the
> > rotatelogs way.  Choice is good.
>
> One thing to be careful of is to put a hyphen before the filename in the
> syslog config. This will stop syslog doing a sync() after *every* message,
> which quite noticably kills performance. Also make sure it's only logging
to
> the logs you want and not to multiple files.

That's right, but I think that all here knew this, or not ?


Ciao
Gaetano



pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: Prepared statement performance...
Next
From: "Shridhar Daithankar"
Date:
Subject: Performance while loading data and indexing