Re: Huge performance penalty with parallel queries in Windows x64 v. Linux x64

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: Huge performance penalty with parallel queries in Windows x64 v. Linux x64
Дата
Msg-id CA+hUKG+d+qrOgwU2sqG09De7W6WJp7edWwURcip+_JxoCzxd4A@mail.gmail.com
обсуждение исходный текст
Ответ на Huge performance penalty with parallel queries in Windows x64 v. Linux x64  (Hans Buschmann <buschmann@nidsa.net>)
Ответы AW: Huge performance penalty with parallel queries in Windows x64 v. Linux x64  (Hans Buschmann <buschmann@nidsa.net>)
Список pgsql-general
On Tue, May 4, 2021 at 4:05 AM Hans Buschmann <buschmann@nidsa.net> wrote:
> The main difference is the time shown for the Gather Merge step (65 ms vs. 7 ms)

No Windows here, but could it be super slow at launching workers?  How
does a trivial parallel query compare, something like?

SET force_parallel_mode = on;
EXPLAIN ANALYZE SELECT 42;



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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: pg_upgrade and wraparound
Следующее
От: Andrew Armstrong
Дата:
Сообщение: Identified cause of potential pg_upgrade failure on Windows due to OS update adding partial block list of ports 50xxxx (could not connect to server)