From: Tom Lane <tgl@sss.pgh.pa.us>
To: Axel Waggershauser <awagger@web.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Low throughput of binary inserts from windows to linux
Date: Mon, 11 Dec 2006 10:59:00 -0500
Message-ID: <12645.1165852740@sss.pgh.pa.us> (raw)
In-Reply-To: <5e66c6e90612110658r3c0918f6v4fd3682363db5c15@mail.gmail.com>
References: <5e66c6e90612080417r23ecaea4p210905f868c26c7f@mail.gmail.com>
<5e66c6e90612081724m57293ffdy21d6b45697e69bd4@mail.gmail.com>
<3317.1165636358@sss.pgh.pa.us>
<5e66c6e90612110658r3c0918f6v4fd3682363db5c15@mail.gmail.com>
"Axel Waggershauser" <awagger@web.de> writes:
> On 12/9/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> 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.
> 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.
Yeah, that's what I couldn't think of the other day. The principal
report was here:
http://archives.postgresql.org/pgsql-general/2005-01/msg01231.php
By default, Windows XP installs the QoS Packet Scheduler service.
It is not installed by default on Windows 2000. After I installed
QoS Packet Scheduler on the Windows 2000 machine, the latency
problem vanished.
Now he was talking about a local connection not remote, but it's still
something worth trying.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, awagger@web.de
Subject: Re: Low throughput of binary inserts from windows to linux
In-Reply-To: <12645.1165852740@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox