Re: Slow access to PostgreSQL server - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: Slow access to PostgreSQL server
Date
Msg-id b42b73150608101355t71a787f0g81d83bd4134fc65@mail.gmail.com
Whole thread Raw
In response to Slow access to PostgreSQL server  (Phil Cairns <phil@pagaros.notpartofaddress.com.au>)
List pgsql-performance
On 8/10/06, Phil Cairns <phil@pagaros.notpartofaddress.com.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

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: slow transfer speeds with PostgreSQL
Next
From: Chris
Date:
Subject: Re: setting up foreign keys