Re: [GENERAL] Performance degradation when using auto_explain
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 по дате отправления:
Предыдущее
От: Pavel StehuleДата:
Сообщение: Re: [GENERAL] vacuum of empty table slows down as database tablecount grows