Re: Low throughput of binary inserts from windows to - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Low throughput of binary inserts from windows to
Date
Msg-id 457D320A.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: Low throughput of binary inserts from windows to linux  ("Axel Waggershauser" <awagger@web.de>)
List pgsql-performance
>>> On Mon, Dec 11, 2006 at  8:58 AM, in message
<5e66c6e90612110658r3c0918f6v4fd3682363db5c15@mail.gmail.com>, "Axel
Waggershauser" <awagger@web.de> 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



pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgresql - Threshold value.
Next
From: Cosimo Streppone
Date:
Subject: Looking for hw suggestions for high concurrency OLTP app