Postgres Pro
Downloads
Home   >   mailing lists

Re: Huge performance penalty with parallel queries in Windows x64 v. Linux x64 - Mailing list pgsql-general

From Thomas Munro
Subject Re: Huge performance penalty with parallel queries in Windows x64 v. Linux x64
Date
Msg-id CA+hUKG+d+qrOgwU2sqG09De7W6WJp7edWwURcip+_JxoCzxd4A@mail.gmail.com
Whole thread Raw
In response to Huge performance penalty with parallel queries in Windows x64 v. Linux x64  (Hans Buschmann <buschmann@nidsa.net>)
Responses AW: Huge performance penalty with parallel queries in Windows x64 v. Linux x64
List pgsql-general
Tree view 
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 by date:

Previous
From: Jan Wieck
Date:
Subject: Re: pg_upgrade and wraparound
Next
From: Andrew Armstrong
Date:
Subject: 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)