Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id D69F09F931E for ; Mon, 11 Dec 2006 11:59:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 74658-09 for ; Mon, 11 Dec 2006 11:58:50 -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 DB3AD9F9312 for ; Mon, 11 Dec 2006 11:59:01 -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 kBBFx0Zj012646; Mon, 11 Dec 2006 10:59:00 -0500 (EST) To: "Axel Waggershauser" cc: pgsql-performance@postgresql.org Subject: Re: Low throughput of binary inserts from windows to linux In-reply-to: <5e66c6e90612110658r3c0918f6v4fd3682363db5c15@mail.gmail.com> References: <5e66c6e90612080417r23ecaea4p210905f868c26c7f@mail.gmail.com> <5e66c6e90612081724m57293ffdy21d6b45697e69bd4@mail.gmail.com> <3317.1165636358@sss.pgh.pa.us> <5e66c6e90612110658r3c0918f6v4fd3682363db5c15@mail.gmail.com> Comments: In-reply-to "Axel Waggershauser" message dated "Mon, 11 Dec 2006 15:58:18 +0100" Date: Mon, 11 Dec 2006 10:59:00 -0500 Message-ID: <12645.1165852740@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/237 X-Sequence-Number: 22293 "Axel Waggershauser" writes: > On 12/9/06, Tom Lane wrote: >> 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. > I searched the archives but found nothing really enlightening > regarding my problem. One large thread regarding win32 was related to > a psql problem related to multiple open handles, other mails referred > to a "QoS" patch but I could not find more specific information. Yeah, that's what I couldn't think of the other day. The principal report was here: http://archives.postgresql.org/pgsql-general/2005-01/msg01231.php By default, Windows XP installs the QoS Packet Scheduler service. It is not installed by default on Windows 2000. After I installed QoS Packet Scheduler on the Windows 2000 machine, the latency problem vanished. Now he was talking about a local connection not remote, but it's still something worth trying. regards, tom lane