Re: pg_dump additional options for performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump additional options for performance
Дата
Msg-id 6124.1204052305@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dump additional options for performance  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: pg_dump additional options for performance  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: pg_dump additional options for performance  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
"Joshua D. Drake" <jd@commandprompt.com> writes:
> IMO the place to start is COPY which is per my tests, slow. Multi
> worker connection restore is great and I have proven that with some
> work it can provide o.k. results but it is certainly not acceptable.

It was already pointed out to you that we can hope for only incremental
speedups in COPY per se.  Don't be too quick to dismiss the discussion
of large-grain parallelism, because I don't see anything else within
reach that might give integer multiples rather than percentage points.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Proposed changes to DTrace probe implementation
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: pg_dump additional options for performance