我无法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/
更多推荐
发布评论