Hi,
I found performance degradation when using auto_explain with log_analyze option true.
It automatically logs query plan analyze results.
But when there are many concurrent sessions, the performance degrades in proportion to the number of concurrent sessions.
These queries are all read-only queries.
And I found that the time consumed in a plan node like IndexScan takes more times when there are many sessions.
At first, I thought that it may be due to CPU scheduling contentions incurs the degradation.
But there are more CPU cores than the session counts.
And finally I found that auto_explain is the cause of the problem.
I am curious now, why auto_explain incurs contentions between the session?
I use Ubuntu linux. Is it a problem of gettimeofday()?
Thank you.
Kisung Kim
--
Bitnine Global Inc., Kisung Kim, Ph.D
https://sites.google.com/site/kisungresearch/
E-mail : kskim@xxxxxxxxxxx
Office phone : 070-4800-5890, 408-606-8602
US Mobile phone :408-805-2192
