X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 40E8D9FB31F for ; Thu, 10 Aug 2006 17:56:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 51158-08 for ; Thu, 10 Aug 2006 20:55:58 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.207]) by postgresql.org (Postfix) with ESMTP id 406029FB2F8 for ; Thu, 10 Aug 2006 17:55:57 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id z31so111115nzd for ; Thu, 10 Aug 2006 13:55:56 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=SQOAUszN5osVuaIQVMzpjKI6fQvpuNpNRYH8u5jx2az+eRJNdxuQRbEfMTb3i6HLe/V7nH+DksRyOz9G/3PefsfDMS0JmxwiKlD/WiN5LeURKZby+YZSiUkGDMyfx4e3fPDZwpVHOGfmJq6uxinPDuXYc47eKDfqE4Q0Cj5ixvw= Received: by 10.65.59.16 with SMTP id m16mr3020261qbk; Thu, 10 Aug 2006 13:55:56 -0700 (PDT) Received: by 10.65.139.10 with HTTP; Thu, 10 Aug 2006 13:55:54 -0700 (PDT) Message-ID: Date: Thu, 10 Aug 2006 16:55:54 -0400 From: "Merlin Moncure" To: "Phil Cairns" Subject: Re: Slow access to PostgreSQL server Cc: pgsql-performance@postgresql.org In-Reply-To: <12dm0u95lncnte0@corp.supernews.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <12dm0u95lncnte0@corp.supernews.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.199 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/198 X-Sequence-Number: 20383 On 8/10/06, Phil Cairns 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