Missing max_parallel_degree configuration parameter in PostgreSql 9.6
NickName:Atiris Ask DateTime:2016-11-08T23:31:24

Missing max_parallel_degree configuration parameter in 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?

Copyright Notice:Content Author:「Atiris」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/40490724/missing-max-parallel-degree-configuration-parameter-in-postgresql-9-6

More about “Missing max_parallel_degree configuration parameter in PostgreSql 9.6” related questions

Missing max_parallel_degree configuration parameter in 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

Show Detail

Postgresql 9.6 InitDB Fails

Whenever I Try running the command below it always fails on RHEL7. I've tried on another similar OS (Newer) and it doesn't do this and just works. I'v looked into permissions of directories, disab...

Show Detail

CPU spike high in postgresql 9.6

We upgraded postgresql from 9.3 to 9.6 and we found that after upgrading postgresql consumes overall 75% of CPU. We are having web based application(JBOSS) which will communicate to postgresql 9.6 ...

Show Detail

E: Package 'postgresql-9.6' has no installation candidate

Linux Mint 20.2 I want to install PostgreSQL 9.6. Here my steps: sudo add-apt-repository "deb https://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main" sudo apt-get update Reading pac...

Show Detail

Unable to initialize the database for PostgreSQL-9.6

I am setting up a new virtual server to run Netbox, an IP address Management server. I am installing all dependencies and am having trouble with PostgreSQL server database initialization. I have

Show Detail

How to manage postgreSQL 9.6 missing WAL segment from master server?

A have a PITR configuration with postgresql 9.6, with a master server, a intermediate server, and two slave servers, hot-standby but manually switched, such as this: Master | I1 / \ S1 S2 A f...

Show Detail

PostgreSQL 9.6 wals management

I'm trying to understand my wals behavior on my PostgreSQL environment. My wal settings are : wal_keep_segments = 200 max_wal_size = 3GB min_wal_size = 80MB archive_command = 'cp %p /PostgreSQL-wal...

Show Detail

Upgrade Postgresql from 9.6 to 11 with different data directory

I am trying to upgrade PostgreSQL version from 9.6 to 11. I am following this link. The problem is I have changed my default location of PostgreSQL data directory from /var/lib/postgresql/ to /opt/

Show Detail

Docker> postgresql9.6 error

I am using docker to install postgresql 9.6 from centos7 image. I got an error while initialize the postgresql and also problem with this service. sh-4.2# usr/pgsql-9.6/bin/postgresql96-setup ini...

Show Detail

PostgreSQL 9.6 parallel aggregates

PostgreSQL in version 9.6 adds support for parallel aggregates. With 9.6, PostgreSQL introduces initial support for parallel execution of large queries. Only strictly read-only queries where ...

Show Detail