On Fri, Sep 15, 2006 at 05:37:50PM +0200, zeljko wrote:
> But, when I try (via tunnel, explained above)
> psql -p 5400 -h localhost mydatabase
> it connects and works fine, but there's no compression.
> Query returns in cca 20 seconds, almost same (maybe 0.5 sec. different) as
> normal psql connection.Conclusion is that there's no compression of psql
> stream. Returned data is varchars and integers.
That's a tenuous conclusion; it assumes that the data transfer is
what's taking all the time. Query planning and execution and
client-side processing must also be taken into account. Using a
sniffer to observe the amount of data transferred would be a more
appropriate test.
--
Michael Fuhr