Request a Demo
Home   >   mailing lists

Re: [GENERAL] Performance degradation when using auto_explain - Mailing list pgsql-general

From Kisung Kim
Subject Re: [GENERAL] Performance degradation when using auto_explain
Date
Msg-id CABF0Rr1Lnt7uRW=19JzwTTQrEDJG4H1Lvv8m=xaTBoxTW6+1hw@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Performance degradation when using auto_explain  (Kisung Kim <kskim@bitnine.net>)
Responses Re: [GENERAL] Performance degradation when using auto_explain
List pgsql-general
Tree view


On Wed, Jan 4, 2017 at 1:21 AM, Andreas Kretschmer <akretschmer@spamfence.net> wrote:
Kisung Kim <kskim@bitnine.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@postgresql.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@bitnine.net
Office phone : 070-4800-5890, 408-606-8602
US Mobile phone : 408-805-2192

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [GENERAL] vacuum of empty table slows down as database tablecount grows
Next
From: Merlin Moncure
Date:
Subject: Re: [GENERAL] Performance PLV8 vs PLPGSQL