Re: PG_DUMP very slow because of STDOUT ?? - Mailing list pgsql-general

From Tom Lane
Subject Re: PG_DUMP very slow because of STDOUT ??
Date
Msg-id 18483.1278682727@sss.pgh.pa.us
Whole thread Raw
In response to PG_DUMP very slow because of STDOUT ??  (Andras Fabian <Fabian@atrada.net>)
Responses 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>)
List 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 by date:

Previous
From: "Tyler Hains"
Date:
Subject: Re: JDBC Postgres problem
Next
From: Andras Fabian
Date:
Subject: Re: PG_DUMP very slow because of STDOUT ??