pgsql: Limit maximum parallel degree to 1024.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Limit maximum parallel degree to 1024.
Date: 2016-05-06 18:55:15
Message-ID: E1aykuB-0001GI-72@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Limit maximum parallel degree to 1024.

This new limit affects both the max_parallel_degree GUC and the
parallel_degree reloption. There may some day be a use case for using
more than 1024 CPUs for a single query, but that's surely not the case
right now. Not only do not very many people have that many CPUs, but
the code hasn't been tested at that kind of scale and is very unlikely
to perform well, or even work at all, without a lot more work. The
issue addressed by commit 06bd458cb812623c3f1fdd55216c4c08b06a8447 is
probably just one problem of many.

The idea of a more reasonable limit here was suggested by Tom Lane;
the value of 1024 was suggested by Amit Kapila.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/c7ea68ff8dfafc22c6cfefdb5929e12ec5d1e02a

Modified Files
--------------
src/backend/access/common/reloptions.c | 2 +-
src/backend/utils/misc/guc.c | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2016-05-06 19:06:20 pgsql: Minimal fix for crash bug in quals_match_foreign_key.
Previous Message Stephen Frost 2016-05-06 18:52:29 Re: pgsql: Add TAP tests for pg_dump