Re: Low throughput of binary inserts from windows to linux

Поиск
Список
Период
Сортировка
От Axel Waggershauser
Тема Re: Low throughput of binary inserts from windows to linux
Дата
Msg-id 5e66c6e90612110658r3c0918f6v4fd3682363db5c15@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Low throughput of binary inserts from windows to linux  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Low throughput of binary inserts from windows to linux  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Low throughput of binary inserts from windows to  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-performance
On 12/9/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "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.

I searched the archives but found nothing really enlightening
regarding my problem. One large thread regarding win32 was related to
a psql problem related to multiple open handles, other mails referred
to a "QoS" patch but I could not find more specific information.

I thought about firewall or virus scanning software myself, but I
can't really see why such software should distinguish between a
windows remote host and a linux remote host. Furthermore,
"downloading" is fast on all setups, it's just uploading from windows
to linux, which is slow.

I repeated my test with a vanilla windows 2000 machine (inc. tons of
microsoft hot-fixes) and it exposes the same problem.

I'm out of ideas here, maybe someone could try to reproduce this
behavior or could point me to the thread containing relevant
information (sorry, maybe I'm just too dumb :-/)

Thank,
  Axel

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: New to PostgreSQL, performance considerations
Следующее
От: "Thomas H."
Дата:
Сообщение: Re: Low throughput of binary inserts from windows to linux