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?
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/
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With