The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/manage-ag-tablespaces.html
Description:
Hi,
"default_tablespace" parameter in "postgresql.conf" does something to
GATHER (in parallel query).
Because when default_tablespace is set to whatever name, and the tablespace
doesn't exist, a query using parallel query is now giving the following
error :
2019-09-25 16:42:50.444 GMT [71530] ERROR: invalid value for parameter
"default_tablespace": "DATA"
2019-09-25 16:42:50.444 GMT [71530] DETAIL: Tablespace "DATA" does not
exist.
So i suggest to add in documentation that this parameter have an effect on
parallel_query.
I will fill in a bug report today for this "side effect".
regards
Virgile