PostgreSql 9.6中缺少max

PostgreSql 9.6中缺少max_parallel_degree配置参数(Missing max_parallel_degree configuration parameter in PostgreSql 9.6)

我无法set max_parallel_degree 。

文档： https ： //wiki.postgresql.org/wiki/Parallel_Query

刚才我把我的postgresql测试数据库服务器从版本9.5.5更新到了9.6 。 服务器重新启动，启动并运行。 根据文档，我应该能够为实际用户设置并行度 ，但该参数不在配置表中。

当我尝试set max_parallel_degree = 4; 我得到这个： 错误：无法识别的配置参数“max_parallel_degree”

我的配置： Ubuntu的服务器（更新），在VirtualBox机中分配6个核心的postgresql 9.6。 我的配置文件：/etc/postgresql/9.6/main/postgresql.conf不包含具有“并行”字的行。 server_version = 9.6.1; psql版本= 9.6.1

select * from pg_settings where name like '%par%';

结果：

debug_print_parse | off force_parallel_mode | on * log_parser_stats | off max_parallel_workers_per_gather | 4 * max_prepared_transactions | 0 min_parallel_relation_size | 1024 parallel_setup_cost | 1000 parallel_tuple_cost | 0.1

*这个设置是在运行psql之后由我设置的。

我能做些什么来启用在PostgreSql 9.6上运行的并行查询？

I am not able to set max_parallel_degree.

Documentation: https://wiki.postgresql.org/wiki/Parallel_Query

Just now I updated my postgresql test database server from version 9.5.5 to 9.6. Server is restarted, up and running. According documentation I should be able to set parallel degree for actual user, but this parameter is not in configuration table.

When I try to set max_parallel_degree = 4; I get this: ERROR: unrecognized configuration parameter "max_parallel_degree"

My configuration: ubuntu server (updated), postgresql 9.6 in VirtualBox machine with 6 cores assigned. My config file: /etc/postgresql/9.6/main/postgresql.conf does not contain rows with "parallel" word. server_version = 9.6.1; psql version = 9.6.1

select * from pg_settings where name like '%par%';

Results:

debug_print_parse | off force_parallel_mode | on * log_parser_stats | off max_parallel_workers_per_gather | 4 * max_prepared_transactions | 0 min_parallel_relation_size | 1024 parallel_setup_cost | 1000 parallel_tuple_cost | 0.1

*This settings was set by me after run psql.

What can I do to enable parallel query running on PostgreSql 9.6?

最满意答案

max_parallel_degree已被重命名为max_parallel_workers_per_gather 。

另外，我们对参数和功能进行了一些用户可见的更改。 这些可能会导致beta 1和beta 2之间的转储/恢复以产生错误。 这包括：

将max_parallel_degree重命名为max_parallel_workers_per_gather

来源： https : //www.postgresql.org/about/news/1677/

The max_parallel_degree has been renamed to max_parallel_workers_per_gather.

Additionally, we've made some user-visible changes to parameters and functions. These may cause dump/restore between beta 1 and beta 2 to generate errors. This includes:

rename max_parallel_degree to max_parallel_workers_per_gather

Source: https://www.postgresql.org/about/news/1677/