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

From Tom Lane
Subject Re: AW: Huge performance penalty with parallel queries in Windows x64 v. Linux x64
Date
Msg-id 3911437.1620146818@sss.pgh.pa.us
Whole thread Raw
In response to AW: Huge performance penalty with parallel queries in Windows x64 v. Linux x64  (Hans Buschmann <buschmann@nidsa.net>)
List pgsql-general
Hans Buschmann <buschmann@nidsa.net> writes:
> In my opinion, even for Linux the default for parallel_setup_cost is set too low (1000). It should reflect the
sequentialaccess of 1000 pages, which normally is faster from buffer cache on modern hardware. 

I tend to agree with you that the default costs for parallel queries
are far too optimistic --- we've seen enough complaints about parallelism
making things slower to make that clear.  However, proposing some new
numbers without gathering some hard evidence to support them is not
helpful.

            regards, tom lane



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"
Next
From: Tomas Vondra
Date:
Subject: Re: Extended stats - value not in MCV list