Re: Low throughput of binary inserts from windows to linux

Поиск
Список
Период
Сортировка
От Florian Weimer
Тема Re: Low throughput of binary inserts from windows to linux
Дата
Msg-id 82vekhwokb.fsf@mid.bfk.de
обсуждение исходный текст
Ответ на Re: Low throughput of binary inserts from windows to linux  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: New to PostgreSQL, performance considerations
Следующее
От: "Jens Schipkowski"
Дата:
Сообщение: Re: really quick multiple inserts can use COPY?