Title: RE: [PERFORM] PG Logging is Slow
Thankyou Alexander,
That has worked and appears to have fixed the issue with syslog.
Theo
-Original Message-
From: Alexander Borkowski [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 21 December 2004 10:09 AM
To: Theo Galanakis
Cc
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 i
Title: RE: [PERFORM] PG Logging is Slow
Thank-you Grega,
I ended up using the pg_ctl -l parameter to write the output to a specified file. Much quicker to do so.
I tried the -/var/log/postgresql.log option however I noticed no performance improvement. May be the fact that
On Mon, Dec 20, 2004 at 03:17:11PM +1100, Theo Galanakis wrote:
> Under postgres 7.3 logging is incredibly slow!
>
> I have applied the following settings:
>
> syslog = 2
> syslog_facility = 'LOCAL0'
> syslog_ident = 'postgres'
>
> log_connections = true
> log_duration = true
> log_pid =
...and on Mon, Dec 20, 2004 at 03:17:11PM +1100, Theo Galanakis used the
keyboard:
> Under postgres 7.3 logging is incredibly slow!
>
> I have applied the following settings:
>
> syslog = 2
> syslog_facility = 'LOCAL0'
> syslog_ident = 'postgres'
>
> log_connections = true
> log_duration =
Theo Galanakis wrote:
> Under postgres 7.3 logging is incredibly slow!
>
> I have applied the following settings:
>
> syslog = 2
> syslog_facility = 'LOCAL0'
> syslog_ident = 'postgres'
>
> log_connections = true
> log_duration = true
> log_pid = true
> log_statement = true
> log_times
