Skip site navigation (1) Skip section navigation (2)

Re: Data transfer very slow when connected via DSL

From: Dimitri <dimitrik(dot)fr(at)gmail(dot)com>
To: "Rainer Bauer" <usenet(at)munnin(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Data transfer very slow when connected via DSL
Date: 2007-06-21 21:32:01
Message-ID: 5482c80a0706211432g170154e7x4ee36e5148d272d5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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 <usenet(at)munnin(dot)com> 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
>

In response to

Responses

pgsql-performance by date

Next:From: Rainer BauerDate: 2007-06-21 22:09:17
Subject: Re: Data transfer very slow when connected via DSL
Previous:From: Rainer BauerDate: 2007-06-21 21:26:43
Subject: Re: Data transfer very slow when connected via DSL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group