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

Re: Data transfer very slow when connected via DSL

From: Rainer Bauer <usenet(at)munnin(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Data transfer very slow when connected via DSL
Date: 2007-06-21 22:09:17
Message-ID: b7tl73pk8u5hptorgnpug6muv0g7bja4q4@4ax.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hello Dimitri,

>but did you try to execute your query directly from 'psql' ?...

munnin=>\timing
munnin=>select * from "tblItem";
<data snipped>
(50 rows)
Time: 391,000 ms

>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'...

Yes, see also my other post.

Unfortunatelly this means that using my program to connect via DSL to the
Postgres database is not possible.

Rainer

In response to

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2007-06-21 22:29:15
Subject: Re: Hardware suggestions
Previous:From: DimitriDate: 2007-06-21 21:32:01
Subject: Re: Data transfer very slow when connected via DSL

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