Kevin Kempter sayeth... > > Hi List; > > Anyone have any thoughts per which logging method (SYSLOG vs > STDERR) is the > better approach ? >
From looking at 8.2.1 source the internal postgres stderr redirect method only does line buffering which explains why we see a performance gain when we turn logging off or have it use syslog instead. Syslog with the '-' option in front of the log file in syslog.conf is a good option. As I understand it, ulog is also a good option but I haven't any experience with it. Logging when the individual log entry is buffered does present a risk of losing a log entry on a system crash but for the purposes of Postgres I would think that such a system crash would have been caused by something external to Postgres and the loss of any logs in this case is okay. Greg ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings