Postgres Pro
Downloads
Home   >   mailing lists

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

From Bharath Rupireddy
Subject Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW
Date
Msg-id CALj2ACXg-4hNKJC6nFnepRHYT4t5jJVstYvri+tKQHy7ydcr8A@mail.gmail.com
Whole thread Raw
Responses Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Two fsync related performance issues?
Next
From: Krunal Bauskar
Date:
Subject: Re: Improving spin-lock implementation on ARM.