Обсуждение: postgres materialized view refresh in parallel

Поиск
Список
Период
Сортировка

postgres materialized view refresh in parallel

От
Ayub M
Дата:
Created materialized view in parallel by setting max_parallel_workers_per_gather to 4. I could see parallel sessions kicking off and creating the mview much faster than serial execution (10mins - parallel vs over an hour - serial).

Now I want the refresh of the mview to happen taking around same time as create, I am okay with it taking little more than create, to execute the steps it takes when refreshing the view. But what I am noticing is, refresh is not running in parallel at all - even after having max_parallel_workers_per_gather to 4. Does PostgreSQL 11.6 not support refresh of the mviews in parallel as it did while creating the mview?