Slow access to PostgreSQL server

From: Phil Cairns <phil(at)pagaros(dot)notpartofaddress(dot)com(dot)au>
To: pgsql-performance(at)postgresql(dot)org
Subject: Slow access to PostgreSQL server
Date: 2006-08-10 10:00:38
Message-ID: 12dm0u95lncnte0@corp.supernews.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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).

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Markus Schaber 2006-08-10 11:07:08 Re: Beginner optimization questions, esp. regarding Tsearch2
Previous Message Richard Huxton 2006-08-10 09:23:55 Re: Beginner optimization questions, esp. regarding Tsearch2