> Something weird about the network stack on the new machine, maybe. > Have you compared the transfer speeds for Unix-socket and TCP connections? Hmm, no ... but how do Unix-socket / TCP connections relate to STDOUT here (sorry, maybe this is obvious to some, but not to me at the moment)? And doing some profiling came to my mind too, but didn't have much experience in that field until now (at least not on basic OS related stuff). I might check out oprofile (yes, it seems to exist for Ubuntu) next week (now its time to leave for the weekend :-) And maybe others have some more ideas until then ... (or have experience this or similar weirdness too). Andras Fabian -----Ursprüngliche Nachricht----- Von: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Gesendet: Freitag, 9. Juli 2010 15:39 An: Andras Fabian Cc: pgsql-general@xxxxxxxxxxxxxx Betreff: Re: PG_DUMP very slow because of STDOUT ?? Andras Fabian <Fabian@xxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
