Postgres Pro
Downloads
Home   >   mailing lists

Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW - Mailing list pgsql-hackers

From Bharath Rupireddy
Subject Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW
Date
Msg-id CALj2ACVvY0D_11GkJVm=KVnQ=R-DGn7NsM+6POp8o_MPpRSmaw@mail.gmail.com
Whole thread Raw
In response to Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Responses RE: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW
List pgsql-hackers
Tree view 
On Tue, Dec 1, 2020 at 5:34 PM Bharath Rupireddy
<bharath.rupireddyforpostgres@gmail.com> wrote:
>
> 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?
>

Added this to commitfest, in case it is useful -
https://commitfest.postgresql.org/31/2856/

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

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: Huge memory consumption on partitioned table with FKs
Next
From: Dean Rasheed
Date:
Subject: Re: Additional improvements to extended statistics