Tom Lane wrote: > Fernando Nasser <[EMAIL PROTECTED]> writes: > > Lamar Owen wrote: > >> Third, it seems that you don't have enough profiling data to support > >> a 'syslog is bad' position. > > > That is true. It is from hearsay, from people who run production > > environments. It may be a belief based on old experiences though. > > I think it's pretty well established that syslog sucks for high log > volume if you run it in the mode where it fsyncs its log after every > message. But I don't believe we have any data that says it's a problem > even if you avoid that pitfall.
What versions of syslog fsync, and where is the syslog.conf option. I don't see it on FreeBSD or Linux. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
