RE: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW

Поиск
Список
Период
Сортировка
От Hou, Zhijie
Тема RE: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW
Дата
Msg-id c1c4fd96d38a4c5b8b490d7b60f88c81@G08CNEXMBPEKD05.g08.fujitsu.local
обсуждение исходный текст
Ответ на Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Ответы Re: Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Список pgsql-hackers
> 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.

Best regards,
houzj



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [PATCH] LWLock self-deadlock detection
Следующее
От: Andres Freund
Дата:
Сообщение: lwlock optimization opportunities