Re: compressed protocol - Mailing list pgsql-general

From zeljko
Subject Re: compressed protocol
Date
Msg-id eeeov2$2p8p$1@news.hub.org
Whole thread Raw
In response to compressed protocol  (zeljko <zeljko@holobit.net>)
List 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


pgsql-general by date:

Previous
From: "Karen Hill"
Date:
Subject: [OT] PHP vs Postgresql argument on Slashdot's front page.
Next
From: zeljko
Date:
Subject: Re: compressed protocol