Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW

Поиск
Список
Период
Сортировка
От Bharath Rupireddy
Тема Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW
Дата
Msg-id CALj2ACXg-4hNKJC6nFnepRHYT4t5jJVstYvri+tKQHy7ydcr8A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Список 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
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Two fsync related performance issues?
Следующее
От: Krunal Bauskar
Дата:
Сообщение: Re: Improving spin-lock implementation on ARM.