Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 3EE0F9FB802 for ; Thu, 21 Jun 2007 18:32:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 67332-05 for ; Thu, 21 Jun 2007 18:32:00 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.228]) by postgresql.org (Postfix) with ESMTP id 3FE429FB7FF for ; Thu, 21 Jun 2007 18:32:03 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id s16so592821wxc for ; Thu, 21 Jun 2007 14:32:01 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=buAKQ+kkFgUavxv9xCaW+GpxrSSKCewUmhCGv9vkCfQSXpV8bk6QCUgpN6g/NtWYO1keb3/maiMXV4oN2ul6GLaOXKFnwaQOxgIVXSW1qoqw1hhfzO/4G9Y6n9ta72WOTx1TBxzF24TDkhSVPLPUDxn4yl07p+dYfBr3VTmH+Sk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=SqwDzqML0unt7bPIub3kuzprhj0cAjhw01vT2qspW7RFXYfHf2uYqe96RfKdGMCGqlTXRUnVGyVJA6ZGDZL33qvX3kwdGrOzzuzFUIHxjdZQ1lvrztia0eykUp46M+L4g0NHuFhRKbTTFwNXrb8ypYhrPxZIxR5HIZRc+jOVpHU= Received: by 10.70.13.1 with SMTP id 1mr3682203wxm.1182461521860; Thu, 21 Jun 2007 14:32:01 -0700 (PDT) Received: by 10.70.90.7 with HTTP; Thu, 21 Jun 2007 14:32:01 -0700 (PDT) Message-ID: <5482c80a0706211432g170154e7x4ee36e5148d272d5@mail.gmail.com> Date: Thu, 21 Jun 2007 23:32:01 +0200 From: Dimitri To: "Rainer Bauer" Subject: Re: Data transfer very slow when connected via DSL Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <16953.1182439969@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/494 X-Sequence-Number: 25527 Hi Rainer, but did you try to execute your query directly from 'psql' ?... Why I'm asking: seems to me your case is probably just network latency dependent, and what I noticed during last benchmarks with PostgreSQL the SELECT query become very traffic hungry if you are using CURSOR. Program 'psql' is implemented to not use CURSOR by default, so it'll be easy to check if you're meeting this issue or not just by executing your query remotely from 'psql'... Rgds, -Dimitri On 6/21/07, Rainer Bauer wrote: > Hello Tom, > > >I seem to recall that we've seen similar reports before, always > >involving Windows :-(. Check whether you have any nonstandard > >components hooking into the network stack on that machine. > > I just repeated the test by booting into "Safe Mode with Network Support", > but > the results are the same. So I don't think that's the cause. > > Apart from that, what response times could I expect? > > Rainer > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq >