Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id EA59B9F931E for ; Tue, 12 Dec 2006 03:39:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 36374-01 for ; Tue, 12 Dec 2006 03:39:28 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mx01.bfk.de (mx01.bfk.de [193.227.124.2]) by postgresql.org (Postfix) with ESMTP id 2AA389F946C for ; Tue, 12 Dec 2006 03:39:27 -0400 (AST) Received: from [10.119.110.2] (helo=mx00.int.bfk.de) by mx01.bfk.de with esmtp id 1Gu2EP-00035Y-8e; Tue, 12 Dec 2006 08:39:17 +0100 Received: from fweimer by bfk.de with local id 1Gu2EO-0002mU-Kt; Tue, 12 Dec 2006 08:39:16 +0100 To: Tom Lane Cc: "Axel Waggershauser" , pgsql-performance@postgresql.org Subject: Re: Low throughput of binary inserts from windows to linux References: <5e66c6e90612080417r23ecaea4p210905f868c26c7f@mail.gmail.com> <5e66c6e90612081724m57293ffdy21d6b45697e69bd4@mail.gmail.com> <3317.1165636358@sss.pgh.pa.us> <5e66c6e90612110658r3c0918f6v4fd3682363db5c15@mail.gmail.com> <12645.1165852740@sss.pgh.pa.us> <5e66c6e90612111444y78729a71m4ec9852ae9bc8567@mail.gmail.com> <21549.1165886726@sss.pgh.pa.us> From: Florian Weimer Date: Tue, 12 Dec 2006 08:39:16 +0100 In-Reply-To: <21549.1165886726@sss.pgh.pa.us> (Tom Lane's message of "Mon, 11 Dec 2006 20:25:26 -0500") Message-ID: <82vekhwokb.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/276 X-Sequence-Number: 22332 * Tom Lane: > If you don't like that theory, another line of reasoning has to do with > the fact that the maximum advertiseable window size in TCP is 65535 --- > there could be some edge-case behaviors in the Windows and Linux stacks > that don't play nicely together for 64K transfer sizes. Linux enables window scaling, so the actual window size can be more than 64K. Windows should cope with it, but some PIX firewalls and other historic boxes won't. --=20 Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstra=DFe 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99