Re: [GENERAL] Copression

2005-03-21 Thread Jan Wieck
On 3/20/2005 10:50 PM, Bruce Momjian wrote: Stanislaw Tristan wrote: It's a possible to compress traffic between server and client while server returns query result? It's a very actually for dial-up users. What is solution? No, unless SSL compresses automatically. You can use ssh port forwarding w

Re: [GENERAL] Copression

2005-03-21 Thread Michael Fuhr
On Mon, Mar 21, 2005 at 12:45:21PM -0500, Greg Stark wrote: > Bruce Momjian writes: > > > > No, unless SSL compresses automatically. > > Without checking the source, I'll bet it does. > Any good encryption system should compress first. I just ran some tests and it doesn't look like OpenSSL doe

Re: [GENERAL] Copression

2005-03-21 Thread Jay Guerette
FWIW: If you use an stunnel or ssh connection of some sort, merely for compression and not security, the ARCFOUR encryption algorithm appears to have the lowest overhead & fastest throughput. Benchmarked it once for exactly this purpose. > > > It's a possible to compress traffic between server and

Re: [GENERAL] Copression

2005-03-21 Thread Greg Stark
Bruce Momjian writes: Bruce Momjian writes: > Stanislaw Tristan wrote: > > It's a possible to compress traffic between server and client while server > > returns query result? > > It's a very actually for dial-up users. > > What is solution? > > No, unless SSL compresses automatically. Witho

Re: [GENERAL] Copression

2005-03-20 Thread Russell Smith
On Mon, 21 Mar 2005 02:50 pm, Bruce Momjian wrote: > Stanislaw Tristan wrote: > > It's a possible to compress traffic between server and client while server > > returns query result? > > It's a very actually for dial-up users. > > What is solution? There is always the possibility of using SSH to t

Re: [GENERAL] Copression

2005-03-20 Thread Neil Conway
Stanislaw Tristan wrote: It's a possible to compress traffic between server and client while server returns query result? It's a very actually for dial-up users. What is solution? You could use an SSH tunnel with compression to achieve this. -Neil ---(end of broadcast)-

Re: [GENERAL] Copression

2005-03-20 Thread Joshua D. Drake
Bruce Momjian wrote: Stanislaw Tristan wrote: It's a possible to compress traffic between server and client while server returns query result? There are a couple of solutions. 1. Mammoth PostgreSQL supports this for libpq, and jdbc based clients. 2. You can use a web services model that use

Re: [GENERAL] Copression

2005-03-20 Thread Bruce Momjian
Stanislaw Tristan wrote: > It's a possible to compress traffic between server and client while server > returns query result? > It's a very actually for dial-up users. > What is solution? No, unless SSL compresses automatically. -- Bruce Momjian| http://candle.pha.pa.

[GENERAL] Copression

2005-03-20 Thread Stanislaw Tristan
It's a possible to compress traffic between server and client while server returns query result? It's a very actually for dial-up users. What is solution? ---(end of broadcast)--- TIP 8: explain analyze is your friend