From: Phil Cairns <phil@pagaros.notpartofaddress.com.au>
To: pgsql-performance@postgresql.org
Subject: Slow access to PostgreSQL server
Date: Thu, 10 Aug 2006 20:00:38 +1000
Message-ID: <12dm0u95lncnte0@corp.supernews.com> (raw)
Hi all,
I have an application that uses PostgreSQL to store its data. The
application and an instance of the database have been installed in three
different locations, and none of these three locations have anything to
do with any of the others. I'm observing a problem in that large
transfers to some machines on the network (specifically while running
pg_dump) are dead slow. In fact, the information is going from the
server to the client machine at dialup speeds over a 100 Mb LAN to some
machines, and full speed to others.
This not a universal problem. Obviously, I'm not experiencing it at my
development location, or I would have found and fixed it by now. One of
the production installations had no problems. The second of the
production environments experienced the problem on one out of 4 laptops
(all the desktop machines were OK) until their technical guy uninstalled
AVG (anti-virus). The third location has 4 laptops that are all slow in
transferring PostgreSQL data, while the desktop machines are OK. There
are no problems with copying files across the network. At the third
location, they have the same software installed on the laptops and
desktops, including the Vet security suite. Suspecting that something
was screwing up the transfers by fiddling with packets, we suspended
Vet, but that didn't help. We're going to try changing NICs and checking
to see what happens when Pg runs on port 80.
Has anyone experienced this sort of thing before? We're running with
8.0.4. My application uses libpg, while another application is using
OLEDB. Both the native and OLEDB layers exhibit the delay on the "slow"
machines, and have no problems on the "fast" machines. Note that the
laptops are in no way inferior to the desktop machines in terms of CPU,
RAM, etc.
TIA,
Phil (yak from the build farm).
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: phil@pagaros.notpartofaddress.com.au
Subject: Re: Slow access to PostgreSQL server
In-Reply-To: <12dm0u95lncnte0@corp.supernews.com>
* 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