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+hUKGLOWBYU9d_mAN9v29gu12-TWj5QT+=8XrP4ojyABZ-TQw@mail.gmail.com
обсуждение исходный текст
Ответ на AW: 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 7:40 PM Hans Buschmann <buschmann@nidsa.net> wrote:
> The problem seems that this (probably inherent) performance disadvantage of windows is not reflected in the cost
model.

https://www.postgresql.org/docs/13/runtime-config-query.html#GUC-PARALLEL-SETUP-COST
is for that.

It might be interesting to do some profiling to see exactly what is
slow.  Presumably CreateProcess(), but I wonder why exactly.

It'd be nice if we had a way to reuse parallel workers, but alas we do
not, yet.  Or threads.

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

Предыдущее
От: Pól Ua Laoínecháin
Дата:
Сообщение: Re: Is this the future of I/O for the RDBMS?
Следующее
От: Turritopsis Dohrnii Teo En Ming
Дата:
Сообщение: How to Host Multiple Mail Domains (Email Hosting) in iRedMail Full Featured Linux Mail Server