Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 9CAE39FA1A7 for ; Mon, 11 Dec 2006 12:25:51 -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 83095-05 for ; Mon, 11 Dec 2006 12:25:36 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id 7F70D9F9312 for ; Mon, 11 Dec 2006 12:25:35 -0400 (AST) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Mon, 11 Dec 2006 10:25:33 -0600 Message-Id: <457D320A.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.1 Date: Mon, 11 Dec 2006 10:25:14 -0600 From: "Kevin Grittner" To: "Tom Lane" , "Axel Waggershauser" Cc: Subject: Re: Low throughput of binary inserts from windows to References: <5e66c6e90612080417r23ecaea4p210905f868c26c7f@mail.gmail.com> <5e66c6e90612081724m57293ffdy21d6b45697e69bd4@mail.gmail.com> <3317.1165636358@sss.pgh.pa.us> <5e66c6e90612110658r3c0918f6v4fd3682363db5c15@mail.gmail.com> In-Reply-To: <5e66c6e90612110658r3c0918f6v4fd3682363db5c15@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/240 X-Sequence-Number: 22296 >>> On Mon, Dec 11, 2006 at 8:58 AM, in message <5e66c6e90612110658r3c0918f6v4fd3682363db5c15@mail.gmail.com>, "Axel Waggershauser" wrote: > > I'm out of ideas here, maybe someone could try to reproduce this > behavior or could point me to the thread containing relevant > information No guarantees that this is the problem, but I have seen similar issues in other software because of delays introduced in the TCP stack by the Nagle algorithm. Turning on TCP_NODELAY has solved such problems. I don't know if PostgreSQL is vulnerable to this, or how it would be fixed in a PostgreSQL environment, but it might give you another avenue to search. -Kevin