Re: [GENERAL] Performance degradation when using auto_explain

2017-01-04 Thread Tomas Vondra
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

Re: [GENERAL] Performance degradation when using auto_explain

2017-01-04 Thread Kisung Kim
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: > >

Re: [GENERAL] Performance degradation when using auto_explain

2017-01-04 Thread Andreas Kretschmer
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