Re: Data transfer very slow when connected via DSL - Mailing list pgsql-performance

From Harald Armin Massa
Subject Re: Data transfer very slow when connected via DSL
Date
Msg-id 7be3f35d0706220324n1b8a41e1q7d235970044da689@mail.gmail.com
Whole thread Raw
In response to Re: Data transfer very slow when connected via DSL  (Rainer Bauer <usenet@munnin.com>)
Responses Re: Data transfer very slow when connected via DSL
List pgsql-performance
Rainer,

>I did not find a solution so far; and for bulk data transfers I now
>programmed a workaround.

But that is surely based on some component installed on the server, isn't it?

Correct. I use a pyro-remote server. On request this remote server copies the relevant rows into a temporary table, uses a copy_to Call to push them into a StringIO-Objekt (that's Pythons version of "In Memory File"), serializes that StringIO-Objekt, does a bz2-compression and transfers the whole block via VPN.

I read on in this thread, and I scheduled to check on psycopg2 and what it is doing with cursors.

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2007 will take place in Vilnius, Lithuania from Monday 9th July to Wednesday 11th July. See you there!

pgsql-performance by date:

Previous
From: Dave Page
Date:
Subject: Re: Data transfer very slow when connected via DSL
Next
From: PFC
Date:
Subject: Re: Data transfer very slow when connected via DSL