From: | Kisung Kim <kskim(at)bitnine(dot)net> |
---|---|
To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Performance degradation when using auto_explain |
Date: | 2017-01-04 05:03:32 |
Message-ID: | CABF0Rr2U1gi3=iXvGfEm_EnbAauXXSKf26GMEKubGp3k5R1yjQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)bitnine(dot)net
Office phone : 070-4800-5890, 408-606-8602
US Mobile phone : 408-805-2192
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-01-04 05:14:29 | Re: Re: could not load library "$libdir/sslutils": in pg_upgrade process |
Previous Message | DrakoRod | 2017-01-04 05:01:18 | Re: could not load library "$libdir/sslutils": in pg_upgrade process |