Re: [PERFORM] PG Logging is Slow

2004-12-20 Thread Michael Adler
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

Re: [PERFORM] PG Logging is Slow

2004-12-20 Thread Theo Galanakis
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

Re: [PERFORM] PG Logging is Slow

2004-12-20 Thread Alexander Borkowski
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

Re: [PERFORM] PG Logging is Slow

2004-12-19 Thread Bruce Momjian
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

Re: [PERFORM] PG Logging is Slow

2004-12-19 Thread Grega Bremec
...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