Re: [GENERAL] Copression

2005-03-21 Thread Greg Stark
Bruce Momjian pgman@candle.pha.pa.us writes: Bruce Momjian pgman@candle.pha.pa.us 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

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 Michael Fuhr
On Mon, Mar 21, 2005 at 12:45:21PM -0500, Greg Stark wrote: Bruce Momjian pgman@candle.pha.pa.us 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

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

[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

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

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

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

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 tunnel