A J <s5...@yahoo.com> writes: > The problem I am now facing in using log_min_duration_statement is that all > the > clients have to write to a single log file in the pg_log directory. So they > have > to wait for the other writes to happen before completing their write. This > seems > to be reason why the measured duration in the log file (for several > concurrent > clients) is way more, infact much more than what was measured by psql timing > from the client side.
Do you have any actual evidence for that being the problem, as opposed to some other effect? Because I don't recall anybody else complaining about this. Personally I'd wonder for example about whether the server has a really slow gettimeofday()... regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin