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

From Florian Weimer
Subject Re: Low throughput of binary inserts from windows to linux
Date
Msg-id 82vekhwokb.fsf@mid.bfk.de
Whole thread Raw
In response to Re: Low throughput of binary inserts from windows to linux  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
* 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.

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: New to PostgreSQL, performance considerations
Next
From: "Jens Schipkowski"
Date:
Subject: Re: really quick multiple inserts can use COPY?