Re: PG_DUMP very slow because of STDOUT ??

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andras Fabian <Fabian(at)atrada(dot)net>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PG_DUMP very slow because of STDOUT ??
Date: 2010-07-09 13:38:47
Message-ID: 18483.1278682727@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andras Fabian <Fabian(at)atrada(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andras Fabian 2010-07-09 13:47:29 Re: PG_DUMP very slow because of STDOUT ??
Previous Message Tyler Hains 2010-07-09 13:36:03 Re: JDBC Postgres problem