Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized

Поиск
Список
Период
Сортировка
Искать
От
Dimitrios Apostolou
Тема
Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized
Дата
Msg-id
4749eb1e-0fd6-f55b-034a-d3c0bbe5ba8b@gmx.net
Ответ на
Список
Дерево обсуждения
Re: ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Frédéric Yhuel <frederic.yhuel@dalibo.com>
>
> FWIW I implemented a pg_restore --freeze patch, see attached. It needs 
> another patch of mine from [1] that implements pg_restore --data-only 
> --clean, which for parallel restores encases each COPY in its own transaction 
> and prepends it with a TRUNCATE. All feedback is welcome.
>
> [1] https://www.postgresql.org/message-id/c61263f2-7472-5dd8-703d-01e683421f61%40gmx.net
>
> It works really fast for the data, and I see that some, but not all items 
> from section=post-data, start parallel plans. For example I see CREATE INDEX 
> spawns parallel workers.

I added it to July's commitfest, mostly to trigger discussion around the 
issue.

https://commitfest.postgresql.org/patch/5826/

Not sure how to mark on the commitfest page that the patch requires 
another patch from another commitfest entry.


Dimitris



В списке pgsql-performance по дате отправления
От: Dimitrios Apostolou
Дата:
FAQ