Re: [ADMIN] syslog slowing the database? - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: [ADMIN] syslog slowing the database?
Date
Msg-id 20040314160018.GB1400@phlogiston.dyndns.org
Whole thread Raw
In response to Re: [ADMIN] syslog slowing the database?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-performance
On Thu, Mar 11, 2004 at 09:34:54AM +0800, Christopher Kings-Lynne wrote:
> >You could also consider not using syslog at all: let the postmaster
> >output to its stderr, and pipe that into a log-rotation program.
>
> Not an option I'm afraid.  PostgreSQL just jams and stops logging after
> the first rotation...

Actually, this is what we do.  Last year we offered an (admittedly
expensive) bespoke log rotator written in Perl for just this purpose.
It was rejected on the grounds that it didn't do anything Apache's
rotator didn't do, so I didn't pursue it.  I'm willing to put it up
on gborg, though, if anyone thinks it'll be worth having around.
FWIW, we use ours in production.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
The plural of anecdote is not data.
        --Roger Brinner

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Drop Tables Very Slow in Postgresql 7.2.1
Next
From: Arjen van der Meijden
Date:
Subject: Large CASE-statement is pretty slow?