From: | Kisung Kim <kskim(at)bitnine(dot)net> |
---|---|
To: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Performance degradation when using auto_explain |
Date: | 2017-01-04 19:54:51 |
Message-ID: | CABF0Rr1Lnt7uRW=19JzwTTQrEDJG4H1Lvv8m=xaTBoxTW6+1hw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Jan 4, 2017 at 1:21 AM, Andreas Kretschmer <
akretschmer(at)spamfence(dot)net> wrote:
> Kisung Kim <kskim(at)bitnine(dot)net> 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
>
>
Thank you for your reply.
I use real hardware.
I am curious timing functions have contentions when multi-threads call them.
>
> Regards, Andreas Kretschmer
> --
> Andreas Kretschmer
> http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
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 | Merlin Moncure | 2017-01-04 22:55:41 | Re: Performance PLV8 vs PLPGSQL |
Previous Message | Pavel Stehule | 2017-01-04 19:33:35 | Re: vacuum of empty table slows down as database table count grows |