From: | zeljko <zeljko(at)holobit(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: compressed protocol |
Date: | 2006-09-15 17:50:02 |
Message-ID: | eeeov2$2p8p$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Michael Fuhr wrote:
> On Fri, Sep 15, 2006 at 06:34:48PM +0200, zeljko wrote:
>> I'm testing over DSL line (test server have 256k Upload and 1MB
>> download). Results are based on this connection.
>> Server : PIV 3Ghz HT, 1GB RAM. (DSL D 1MB U 256k)
>> Client : PIV 3Ghz HT, 1GB RAM. (DSL D 3MB U 384k).
>>
>> nTier results shows real compression (faster more than twice).
>
> What does a sniffer like tcpdump or wireshark/ethereal show? Let's
> see how much data is being sent over a compressed vs. uncompressed
> connection and how long the data transfers are taking.
>
I've tried sniffing with ethereal , but there's too much data, this is what
ssh with -v command parameter says. (amount of incoming data and
compression factor). It shows minor compression with query data.
ls -al /usr/lib
This is ssh log (compression enabled):
debug1: compress incoming: raw data 135639, compressed 20931, factor 0.15
Same query as in my previous posts.
This is ssh log (compression enabled):
debug1: compress incoming: raw data 682162, compressed 680894, factor 1.00
Query which returns integer field only:
debug1: compress incoming: raw data 193514, compressed 192030, factor 0.99
Query which returns varchar(3) only:
debug1: compress incoming: raw data 178999, compressed 177505, factor 0.99
From | Date | Subject | |
---|---|---|---|
Next Message | zeljko | 2006-09-15 17:58:54 | Re: compressed protocol |
Previous Message | Karen Hill | 2006-09-15 17:24:57 | [OT] PHP vs Postgresql argument on Slashdot's front page. |