Hi Tom (or others), are there some recommended settings/ways to use oprofile on a situation like this??? I got it working, have seen a first profile report, but then managed to completely freeze the server on a second try with different oprofile settings (next tests will go against the newly installed - next and identical - new servers).
Andras Fabian -----Ursprüngliche Nachricht----- Von: Tom Lane [mailto:t...@sss.pgh.pa.us] Gesendet: Freitag, 9. Juli 2010 15:39 An: Andras Fabian Cc: pgsql-general@postgresql.org Betreff: Re: [GENERAL] PG_DUMP very slow because of STDOUT ?? Andras Fabian <fab...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
