pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alexander Borkowski <alexander.borkowski@abri.une.edu.au>
To: Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
Cc: 'pgsql-performance@postgresql.org' <pgsql-performance@postgresql.org>
Subject: Re: PG Logging is Slow
Date: Tue, 21 Dec 2004 10:09:06 +1100
Message-ID: <41C75B92.7000807@abri.une.edu.au> (raw)
In-Reply-To: <16C0CF355FA04944A69E5A4F5299D30B110EAC@ganesh.au.lpint.net>
References: <16C0CF355FA04944A69E5A4F5299D30B110EAC@ganesh.au.lpint.net>

Theo,

 > 	I tried the -/var/log/postgresql.log option however I noticed no
 > performance improvement. May be the fact that we use redhad linux and
 > syslog, I'm no sys-admin, so I'm not sure if there is a difference 
between
 > syslogd and syslog.

Did you restart syslogd (that's the server process implementing the 
syslog (= system log) service) after you changed its configuration?

In order to do so, try running

/etc/init.d/syslog restart

as root from a commandline.

HTH

Alex



view thread (7+ messages)  latest in thread

Message-ID: <41C75B92.7000807@abri.une.edu.au>
Permalink:  ../41C75B92.7000807@abri.une.edu.au/
Also on:    postgresql.org/message-id/41C75B92.7000807@abri.une.edu.au

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: alexander.borkowski@abri.une.edu.au, Theo.Galanakis@lonelyplanet.com.au
  Subject: Re: PG Logging is Slow
  In-Reply-To: <41C75B92.7000807@abri.une.edu.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox