On 01/04/2017 08:54 PM, Kisung Kim wrote:
On Wed, Jan 4, 2017 at 1:21 AM, Andreas Kretschmer
mailto:akretsch...@spamfence.net>> wrote:
Kisung Kim mailto:ks...@bitnine.net>> wrote:
> And finally I found that auto_explain is the cause of the problem.
real hardware or virtual hardwa
On Wed, Jan 4, 2017 at 1:21 AM, Andreas Kretschmer <
akretsch...@spamfence.net> wrote:
> Kisung Kim wrote:
>
> > And finally I found that auto_explain is the cause of the problem.
>
> real hardware or virtual hardware? On virtual there are sometimes
> problems with exact timings, please read:
>
>
Kisung Kim wrote:
> And finally I found that auto_explain is the cause of the problem.
real hardware or virtual hardware? On virtual there are sometimes
problems with exact timings, please read:
https://www.postgresql.org/docs/current/static/pgtesttiming.html
Regards, Andreas Kretschmer
--
A
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 que