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 = true
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 we use redhad
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
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_timestamp = true
...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 = true