Re: comunication protocol - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: comunication protocol
Date
Msg-id 1186692857.7100.1.camel@hannu-laptop
Whole thread Raw
In response to Re: comunication protocol  (Omar Bettin <o.bettin@tiscali.it>)
Responses Re: communication protocol  (Omar Bettin <o.bettin@tiscali.it>)
List pgsql-hackers
Ühel kenal päeval, N, 2007-08-09 kell 17:12, kirjutas Omar Bettin:
> 

> So, you aren't agree with the compression...
> 
> I have sow the network statistics and in some cases, the network traffic 
> is very big.
> Probably a better setup could increase the performance by a few points 
> percent but
> I think a compressed protocol could increase the communication by 2/3 times.
> 
> I think the biggest bottleneck in the whole system is just that.
> 
> :..try to get a query from a remote server with a 56k modem! :)

Why not just set up an ssh2 tunnel with both encryption and compression
and access your remote db over that ?

----------
Hannu



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Compilation of pg 7.4.17 fails on HP-UX
Next
From: Hannu Krosing
Date:
Subject: Re: crypting prosrc in pg_proc