| From: | Florian Weimer <fweimer(at)bfk(dot)de> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Axel Waggershauser" <awagger(at)web(dot)de>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Low throughput of binary inserts from windows to linux |
| Date: | 2006-12-12 07:39:16 |
| Message-ID: | 82vekhwokb.fsf@mid.bfk.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)bfk(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jens Schipkowski | 2006-12-12 07:45:49 | Re: really quick multiple inserts can use COPY? |
| Previous Message | Tom Lane | 2006-12-12 06:47:28 | Re: New to PostgreSQL, performance considerations |