Re: Slow access to PostgreSQL server

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Phil Cairns" <phil(at)pagaros(dot)notpartofaddress(dot)com(dot)au>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow access to PostgreSQL server
Date: 2006-08-10 20:55:54
Message-ID: b42b73150608101355t71a787f0g81d83bd4134fc65@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 8/10/06, Phil Cairns <phil(at)pagaros(dot)notpartofaddress(dot)com(dot)au> wrote:
> 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.

there have been numerous problems reported on windows due to various
applications, especially malware and virus scanners, that cause this
problem. be especially cautious about anything that runs in kernel
mode or runs as a LSP.

merlin

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Chris 2006-08-10 22:36:11 Re: setting up foreign keys
Previous Message Merlin Moncure 2006-08-10 20:51:16 Re: slow transfer speeds with PostgreSQL