Re: PG_DUMP very slow because of STDOUT ??

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PG_DUMP very slow because of STDOUT ??
Дата
Msg-id 18483.1278682727@sss.pgh.pa.us
обсуждение исходный текст
Ответ на PG_DUMP very slow because of STDOUT ??  (Andras Fabian <Fabian@atrada.net>)
Ответы Re: PG_DUMP very slow because of STDOUT ??  (Andras Fabian <Fabian@atrada.net>)
Re: PG_DUMP very slow because of STDOUT ??  (Andras Fabian <Fabian@atrada.net>)
Список pgsql-general
Andras Fabian <Fabian@atrada.net> writes:
> Now I ask, whats going on here ???? Why is COPY via STDOUT so much slower on out new machine?

Something weird about the network stack on the new machine, maybe.
Have you compared the transfer speeds for Unix-socket and TCP connections?

On a Red Hat box I would try using oprofile to see where the bottleneck
is ... don't know if that's available for Ubuntu.

            regards, tom lane

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

Предыдущее
От: "Tyler Hains"
Дата:
Сообщение: Re: JDBC Postgres problem
Следующее
От: Andras Fabian
Дата:
Сообщение: Re: PG_DUMP very slow because of STDOUT ??