Re: [PERFORM] postgresql and syslog

2009-08-07 Thread Michael Nacos
we have actually gone the opposite way and switched to using syslog for logging purposes some time ago, with no performance issues. syslog files are easily read by a lot of applications out there. We have been using rsyslog for aggregating logs from multiple servers, splunk for analysis purposes

Re: [PERFORM] postgresql and syslog

2009-08-07 Thread Alvaro Herrera
Michael Nacos escribió: I would be very surprised if logging had a significant overhead any method you choose. there's probably something very wrong with your setup if this is the case. Either something very wrong, or the load is extremely high. In the latter case perhaps it would make sense

[PERFORM] postgresql and syslog

2009-08-04 Thread Ibrahim Harrani
Hi, I am using postgresql 8.3 with FreeBSD. FreeBSD is using syslog by default for postgresql logs. I would like to disable syslog in postgresql.conf. Does this change increase the performance? What is the impact of using syslog on postgresql performance? Thanks. -- Sent via pgsql-performance