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

From Tom Lane
Subject Re: Low throughput of binary inserts from windows to linux
Date
Msg-id 3317.1165636358@sss.pgh.pa.us
Whole thread Raw
In response to Re: Low throughput of binary inserts from windows to linux  ("Axel Waggershauser" <awagger@web.de>)
Responses Re: Low throughput of binary inserts from windows to linux  ("Axel Waggershauser" <awagger@web.de>)
List pgsql-performance
"Axel Waggershauser" <awagger@web.de> 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

pgsql-performance by date:

Previous
From: "Axel Waggershauser"
Date:
Subject: Re: Low throughput of binary inserts from windows to linux
Next
From: "Daniel van Ham Colchete"
Date:
Subject: New to PostgreSQL, performance considerations