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

From scott.marlowe
Subject Re: rotatelog / logrotate with PostgreSQL
Date
Msg-id Pine.LNX.4.33.0209260837470.26236-100000@css120.ihs.com
Whole thread Raw
In response to Re: rotatelog / logrotate with PostgreSQL  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
On Thu, 26 Sep 2002, Martijn van Oosterhout wrote:

> 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.

Thanks, I'll try that.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Performance while loading data and indexing
Next
From: Tom Lane
Date:
Subject: Re: Adding "on delete cascade" after table creation ?