Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW

Поиск
Список
Период
Сортировка
От Bharath Rupireddy
Тема Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW
Дата
Msg-id CALj2ACV-Ru+DNDvxVLv9tZhPqxEema4YUGymXkDYS9UpS8Zm7g@mail.gmail.com
обсуждение исходный текст
Ответ на RE: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW  ("Hou, Zhijie" <houzj.fnst@cn.fujitsu.com>)
Ответы Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW  (Luc Vlaming <luc@swarm64.com>)
Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW  (Luc Vlaming <luc@swarm64.com>)
Список pgsql-hackers
On Wed, Dec 30, 2020 at 8:03 AM Hou, Zhijie <houzj.fnst@cn.fujitsu.com> wrote:
> > Yeah without explain analyze we can not show whether the parallelism is
> > picked in the test cases. What we could do is that we can add a plain RMV
> > test case in write_parallel.sql after CMV so that at least we can be ensured
> > that the parallelism will be picked because of the enforcement there. We
> > can always see the parallelism for the select part of explain analyze CMV
> > in write_parallel.sql and the same select query gets planned even in RMV
> > cases.
> >
> > IMO, the patch in this thread can go with test case addition to
> > write_parallel.sql. since it is very small.
> >
> > Thoughts?
>
> Yes, agreed.

Thanks. Added the test case. Attaching v2 patch. Please have a look.


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

Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Cleanup some -I$(libpq_srcdir) in makefiles
Следующее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Parallel Inserts in CREATE TABLE AS