Re: Performance degradation when using auto_explain

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

In response to

Responses

Browse pgsql-general by date

  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