Re: [HACKERS] Parallel COPY FROM execution

Поиск
Список
Период
Сортировка
От Alex K
Тема Re: [HACKERS] Parallel COPY FROM execution
Дата
Msg-id CADfU8WxEn4aYhk4oC-SgG9UVMZ9zW7z0XxcB=m-QMqJDFdawQg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Parallel COPY FROM execution  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: [HACKERS] Parallel COPY FROM execution  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
On Fri, Jun 30, 2017 at 3:35 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>
>
> 2017-06-30 14:23 GMT+02:00 Alex K <kondratov.aleksey@gmail.com>:
>>
>> Thus, it results in a ~60% performance boost per each x2 multiplication of
>> parallel processes, which is consistent with the initial estimation.
>>
>
> the important use case is big table with lot of indexes. Did you test
> similar case?

Not yet, I will try it, thank you for a suggestion. But how much is it
'big table' and 'lot of indexes' in numbers approximately?

Also, index updates and constraint checks performance are what I cannot
control during COPY execution, so probably I have not to care too much
about that. But of course, it is interesting, how does COPY perform in
that case.


Alexey



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

Предыдущее
От: Mark Dilger
Дата:
Сообщение: Re: [HACKERS] Request more documentation for incompatibility of parallelism and plpgsql exec_run_select
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: [HACKERS] Parallel COPY FROM execution