Re: PG Logging is Slow

From: Theo Galanakis <Theo(dot)Galanakis(at)lonelyplanet(dot)com(dot)au>
To: 'Alexander Borkowski' <alexander(dot)borkowski(at)abri(dot)une(dot)edu(dot)au>
Cc: "'pgsql-performance(at)postgresql(dot)org'" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: PG Logging is Slow
Date: 2004-12-21 05:53:51
Message-ID: 16C0CF355FA04944A69E5A4F5299D30B110EB6@ganesh.au.lpint.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Thankyou Alexander,

That has worked and appears to have fixed the issue with syslog.

Theo

-----Original Message-----
From: Alexander Borkowski [mailto:alexander(dot)borkowski(at)abri(dot)une(dot)edu(dot)au]
Sent: Tuesday, 21 December 2004 10:09 AM
To: Theo Galanakis
Cc: 'pgsql-performance(at)postgresql(dot)org'
Subject: Re: [PERFORM] PG Logging is Slow

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

______________________________________________________________________
This email, including attachments, is intended only for the addressee
and may be confidential, privileged and subject to copyright. If you
have received this email in error, please advise the sender and delete
it. If you are not the intended recipient of this email, you must not
use, copy or disclose its content to anyone. You must not copy or
communicate to others content that is confidential or subject to
copyright, unless you have the consent of the content owner.

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-12-21 05:58:14 Re: [PERFORM] Postgres version change - pg_dump
Previous Message kondo_yo 2004-12-21 05:04:08 Re: Question of performance of version 8