Parallel Query

From: Krithika Venkatesh <krithikavenkatesh31(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Parallel Query
Date: 2018-01-11 06:54:16
Message-ID: CAP7eca0a80n2X4jn7rn9mDRFOb7CdonX_G9USytwfdihGOAbow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Durumdara 2018-01-11 08:57:07 Re: String comparison problem in select - too many results
Previous Message Andreas 'ads' Scherbaum 2018-01-11 03:35:36 FOSDEM booth volunteer