Re: Question Regarding Merge Append and Parallel Execution of Index Scans on Partitioned Table

From: Ayush Vatsa <ayushvatsa1810(at)gmail(dot)com>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Question Regarding Merge Append and Parallel Execution of Index Scans on Partitioned Table
Date: 2025-06-05 13:47:28
Message-ID: CACX+KaOkMBXd1DTuo1Qn5J3=Gt+3bMT55ZcgOtxhndQO-ZE2cw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Merge Append does not support parallelism.
Thanks for the confirmation.

> We have Gather Merge, which handles executing some
sub-nodes and making sure the results get output in the correct order
A small follow-up question - Gather merge won't gather and merge the
output from child in sorted order, but will always need an explicit Sort
node beneath it to do so. Correct?

-------------------
Thanks,
Ayush Vatsa
SDE AWS

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Feike Steenbergen 2025-06-05 13:54:28 Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them
Previous Message Christoph Berg 2025-06-05 13:35:19 Re: Retiring some encodings?