Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 879979F9F46 for ; Fri, 8 Dec 2006 23:52:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 88683-06 for ; Fri, 8 Dec 2006 23:52:33 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id A2B8C9F9C35 for ; Fri, 8 Dec 2006 23:52:39 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kB93qcbK003318; Fri, 8 Dec 2006 22:52:38 -0500 (EST) To: "Axel Waggershauser" cc: pgsql-performance@postgresql.org Subject: Re: Low throughput of binary inserts from windows to linux In-reply-to: <5e66c6e90612081724m57293ffdy21d6b45697e69bd4@mail.gmail.com> References: <5e66c6e90612080417r23ecaea4p210905f868c26c7f@mail.gmail.com> <5e66c6e90612081724m57293ffdy21d6b45697e69bd4@mail.gmail.com> Comments: In-reply-to "Axel Waggershauser" message dated "Sat, 09 Dec 2006 02:24:13 +0100" Date: Fri, 08 Dec 2006 22:52:38 -0500 Message-ID: <3317.1165636358@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/189 X-Sequence-Number: 22245 "Axel Waggershauser" writes: > ... This works quite well for the > following setups: > client -> server > ----------------- > linux -> linux > linux -> windows > windows -> windows > but pretty bad (meaning about 10 times slower) for this setup > windows -> linux This has to be a network-level problem. IIRC, there are some threads in our archives discussing possibly-related performance issues seen with Windows' TCP stack. Don't recall details, but I think in some cases the problem was traced to third-party add-ons to the Windows stack. You might want to check just what you're running there. regards, tom lane