From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: virgile.crevon@dassault-aviation.com
Subject: default_tablespace and parallel queries
Date: Thu, 26 Sep 2019 12:38:24 +0000
Message-ID: <156950150435.1208.13620233301096219314@wrigleys.postgresql.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, virgile.crevon@dassault-aviation.com
Subject: Re: default_tablespace and parallel queries
In-Reply-To: <156950150435.1208.13620233301096219314@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox