Re: Parallel query execution

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Parallel query execution
Дата
Msg-id 20130116200714.GM16126@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Parallel query execution  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Parallel query execution  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Parallel query execution  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
* Bruce Momjian (bruce@momjian.us) wrote:
> I am not sure how a COPY could be easily parallelized, but I supposed it
> could be done as part of the 1GB segment feature.  People have
> complained that COPY is CPU-bound, so it might be very interesting to
> see if we could offload some of that parsing overhead to a child.

COPY can certainly be CPU bound but before we can parallelize that
usefully we need to solve the problem around extent locking when trying
to do multiple COPY's to the same table.
Thanks,
    Stephen

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [PATCH] COPY .. COMPRESSED
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: [PATCH] COPY .. COMPRESSED