CODEWITHSUNDEEP
postgresqlpostgresql-9.1
Jyoti
Jyoti

Reputation: 21

getting "ERROR: unrecognized configuration parameter "max_parallel_workers_per_gather" while doing parallel processing in Postgres SQL

My Code

  SET max_parallel_workers_per_gather = 2;

Error

ERROR:  unrecognized configuration parameter "max_parallel_workers_per_gather"

Note- While using Postgres SQL when i want to enable parallel processing, I am getting the above mentioned error.

Upvotes: 0

Views: 4135

Answers (1)

infinity_milesman
infinity_milesman

Reputation: 74

I am using postgresql 9.6 and I got no error.

Here's how I did it:

open /etc/postgresql/9.6/main/postgresql.conf with root permission uncomment max_parallel_workers_per_gather and set the value accordingly. save it and then just restart the postgresql by

sudo service postgresql restart

Inside of postgresql.conf:-

max_worker_processes = 8               # (change requires restart)
max_parallel_workers_per_gather = 4     # taken from max_worker_processes

Upvotes: 2

Related Questions