Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW

From: Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW
Date: 2020-12-01 12:04:04
Message-ID: CALj2ACXg-4hNKJC6nFnepRHYT4t5jJVstYvri+tKQHy7ydcr8A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I think we can pass CURSOR_OPT_PARALLEL_OK to pg_plan_query() for
refresh mat view so that parallelism can be considered for the SELECT
part of the previously created mat view. The refresh mat view queries
can be faster in cases where SELECT is parallelized.

Attaching a small patch. Thoughts?

With Regards,
Bharath Rupireddy.
EnterpriseDB: http://www.enterprisedb.com

Attachment Content-Type Size
v1-0001-Allow-parallel-mode-in-REFRESH-MAT-VIEW-planning.patch application/octet-stream 1.0 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Krunal Bauskar 2020-12-01 12:43:38 Re: Improving spin-lock implementation on ARM.
Previous Message Craig Ringer 2020-12-01 11:39:30 Re: Two fsync related performance issues?