Re: parallel pg_restore - WIP patch

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: parallel pg_restore - WIP patch
Дата
Msg-id 48E0D1EE.9010504@dunslane.net
обсуждение исходный текст
Ответ на Re: parallel pg_restore - WIP patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: parallel pg_restore - WIP patch
Список pgsql-hackers

Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
>   
>> Tom Lane wrote:
>>     
>>> Hmm, I'll bet the restore code doesn't realize that this can't run in
>>> parallel with index creation on either table ...
>>>       
>
>   
>> Yeah. Of course, it's never needed to bother with stuff like that till now.
>>     
>
>   
>> The very simple fix is probably to run a separate parallel cycle just 
>> for FKs, after the index creation.
>>     
>
> Um, FKs could conflict with each other too, so that by itself isn't
> gonna fix anything.
>
>             
>   

Good point. Looks like we'll need to make a list of "can't run in 
parallel with" items as well as strict dependencies.

cheers

andrew


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

Предыдущее
От: Markus Wanner
Дата:
Сообщение: Re: Proposal: move column defaults into pg_attribute along with attacl
Следующее
От: Tom Lane
Дата:
Сообщение: Re: parallel pg_restore - WIP patch