From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Rainer Bauer <usenet@munnin.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Data transfer very slow when connected via DSL
Date: Thu, 21 Jun 2007 18:23:06 -0500
Message-ID: <467B085A.3050104@g2switchworks.com> (raw)
In-Reply-To: <b7tl73pk8u5hptorgnpug6muv0g7bja4q4@4ax.com>
References: <s7tk73d57kvb3f4ph1kmkvhdfe0kak5a1r@4ax.com>
<16953.1182439969@sss.pgh.pa.us>
<a1el7395bhsv3n867kvefucj90l808hi54@4ax.com>
<5482c80a0706211432g170154e7x4ee36e5148d272d5@mail.gmail.com>
<b7tl73pk8u5hptorgnpug6muv0g7bja4q4@4ax.com>
Rainer Bauer wrote:
> 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.
Note that I'm connected via wireless lan here at work (our wireless lan
doesn't connecto to our internal lan directly due to PCI issues) then to
our internal network via VPN.
We are using Cisco with Cisco's vpn client software. I am running
Fedora core 4 on my laptop and I can fetch 10,000 rather chubby rows (a
hundred or more bytes) in about 7 seconds.
So, postgresql over vpn works fine here. Note, no windows machines were
involved in the making of this email. One is doing the job of tossing
it on the internet when I hit send though.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: smarlowe@g2switchworks.com, usenet@munnin.com
Subject: Re: Data transfer very slow when connected via DSL
In-Reply-To: <467B085A.3050104@g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox