Hi All,
I was reading about parallel queries in postgresql 10.
I came across the property max_parallel_workers_per_gather. It sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
I am not able to understand gather and gather merge node.
What is the difference between max_parallel_workers_per_gather and max_parallel_processes. What is meant by gather node.
Please let me know.
Thanks,
Krithika