Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW

Поиск
Список
Период
Сортировка
От Bharath Rupireddy
Тема Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW
Дата
Msg-id CALj2ACVvY0D_11GkJVm=KVnQ=R-DGn7NsM+6POp8o_MPpRSmaw@mail.gmail.com
обсуждение исходный текст
Ответ на Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Ответы RE: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW  ("Hou, Zhijie" <houzj.fnst@cn.fujitsu.com>)
Список pgsql-hackers
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 по дате отправления:

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: Huge memory consumption on partitioned table with FKs
Следующее
От: Dean Rasheed
Дата:
Сообщение: Re: Additional improvements to extended statistics