Horton

crashes due to setting max_parallel_workers=0

Tomas Vondra <tomas.vondra@2ndquadrant.com>

View thread View on postgr.es
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>, Robert Haas <robertmhaas@gmail.com>
Date: 2017-03-25T02:10:59Z
Lists: pgsql-hackers

Attachments

Hi,

while working on a patch I ran into some crashes that seem to be caused 
by inconsistent handling of max_parallel_workers - queries still seem to 
be planned with parallel plans enabled, but then crash at execution.

The attached script reproduces the issue on a simple query, causing 
crashed in GatherMerge, but I assume the issue is more general.

regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

  1. Avoid GatherMerge crash when there are no workers.