Re: Query is over 2x slower with jit=on

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Query is over 2x slower with jit=on
Дата
Msg-id 20180822165155.tjbib4pewnbiyy4x@alap3.anarazel.de
обсуждение исходный текст
Ответ на Sv: Re: Query is over 2x slower with jit=on  (Andreas Joseph Krogh <andreas@visena.com>)
Ответы Sv: Re: Query is over 2x slower with jit=on  (Andreas Joseph Krogh <andreas@visena.com>)
Re: Query is over 2x slower with jit=on  (Pierre Ducroquet <p.psql@pinaraf.info>)
Re: Query is over 2x slower with jit=on  (Amit Khandekar <amitdkhan.pg@gmail.com>)
Список pgsql-hackers
On 2018-08-22 18:39:18 +0200, Andreas Joseph Krogh wrote:
> Just to be clear; The query really runs slower (wall-clock time), it's not 
> just the timing.

I bet it's not actually running slower, it "just" takes longer to start
up due to the JITing in each worker. I suspect what we should do is to
multiple the cost limits by the number of workers, to model that.  But
without the fixed instrumentation that's harder to see...

Greetings,

Andres Freund


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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Stored procedures and out parameters
Следующее
От: David Steele
Дата:
Сообщение: Re: Windows vs C99 (was Re: C99 compliance for src/port/snprintf.c)