Re: Low throughput of binary inserts from windows to linux

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Axel Waggershauser" <awagger(at)web(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Low throughput of binary inserts from windows to linux
Date: 2006-12-09 03:52:38
Message-ID: 3317.1165636358@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Axel Waggershauser" <awagger(at)web(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Daniel van Ham Colchete 2006-12-10 19:41:46 New to PostgreSQL, performance considerations
Previous Message Axel Waggershauser 2006-12-09 01:24:13 Re: Low throughput of binary inserts from windows to linux