Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> writes: > In this case, the INSERT *needs* 20 minutes to return. This is because the logging through syslog seems to severely slow the system. > If instead, i use stderr, even with logging_collector=on, the same statement needs 15 seconds to return. Hmm. There's a function in elog.c that breaks log messages into chunks for syslog. I don't think anyone's ever looked hard at its performance --- maybe there's an O(N^2) behavior? regards, tom lane
