Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution
Дата
Msg-id CAEepm=0OFFHRkDUYzdHFPpQeki6b5U59PjOF7KW17PseH4vSCA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14889: explain analyze is taking much more time than actual execution  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On Tue, Nov 7, 2017 at 3:43 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The size of the overhead in this case implies that gettimeofday() is doing
> a kernel call, which I wouldn't really have expected on any modern Linux
> kernel.  What hardware is this on?  Is there virtualization involved?

A virtual server with no vDSO, I'll bet.  Like this:

https://stackoverflow.com/questions/42622427/gettimeofday-not-using-vdso

-- 
Thomas Munro
http://www.enterprisedb.com


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution
Следующее
От: Yan Maystrenko
Дата:
Сообщение: [BUGS] Returning same row twice in certain conditions