PGSQL PERFORMANCE 43 RE PG LOGGING IS SLOW
From: Theo.Galanakis@no-spam (Theo Galanakis)
Subject: Re: PG Logging is Slow
Date: Tue, 21 Dec 2004 16:53:51 +1100


Thankyou Alexander,

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

Theo
-----Original Message-----



















From: Alexander Borkowski [mailto:alexander.borkowski@no-spam
Sent: Tuesday, 21 December 2004 10:09 AM To: Theo Galanakis Cc: 'pgsql-performance@no-spam
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.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=
=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version=
5.5.2654.45">
<TITLE>RE: [PERFORM] PG Logging is Slow</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Thankyou Alexander,</FONT>
</P>

<P>        <FONT SIZE=3D2>That has=
worked and appears to have fixed the issue with syslog.</FONT>
</P>

<P><FONT SIZE=3D2>Theo</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Alexander Borkowski [<A HREF=
=3D"mailto:alexander.borkowski@no-spam">mailto:alexander.borkowski@no-spam abri.une.edu.au</A>] </FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, 21 December 2004 10:09 AM</FONT>
<BR><FONT SIZE=3D2>To: Theo Galanakis</FONT>
<BR><FONT SIZE=3D2>Cc: 'pgsql-performance@no-spam</FONT>
<BR><FONT SIZE=3D2>Subject: Re: [PERFORM] PG Logging is Slow</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Theo,</FONT>
</P>

<P><FONT SIZE=3D2> >      I tried the=
-/var/log/postgresql.log option however I noticed no</FONT>
<BR><FONT SIZE=3D2> > 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 </FONT></P>

<P><FONT SIZE=3D2>between</FONT>
<BR><FONT SIZE=3D2> > syslogd and syslog.</FONT>
</P>

<P><FONT SIZE=3D2>Did you restart syslogd (that's the server process=
implementing the </FONT>
<BR><FONT SIZE=3D2>syslog (=3D system log) service) after you changed its=
configuration?</FONT>
</P>

<P><FONT SIZE=3D2>In order to do so, try running</FONT>
</P>

<P><FONT SIZE=3D2>/etc/init.d/syslog restart</FONT>
</P>

<P><FONT SIZE=3D2>as root from a commandline.</FONT>
</P>

<P><FONT SIZE=3D2>HTH</FONT>
</P>

<P><FONT SIZE=3D2>Alex</FONT>
</P>

</BODY>
</HTML>
<table><tr><td bgcolor=3D#ffffff><font color=
=3D#000000>________________________________________________________________=
______<br>
This email, including attachments, is intended only for the addressee<br>
and may be confidential, privileged and subject to copyright. If you<br>
have received this email in error, please advise the sender and delete<br>
it. If you are not the intended recipient of this email, you must not<br>
use, copy or disclose its content to anyone. You must not copy or <br>
communicate to others content that is confidential or subject to <br>
copyright, unless you have the consent of the content owner.<br>
</font></td></tr></table>