Traffic compression

### Feature Description

Good day to you!

We're seeing internet speed cap being a bottleneck on some of the dump operations we perform. Since compressed dumps can be less than ten times what the uncompressed dump is, I thought, it could be an interesting enhancement to add compression to the proxied traffic.

I understand that this would also involve the proxy software on the other end, so not sure if this is the right repo to submit a feature request like this, and it's high effort/low prio, but still submitting this just in case.

### Sample code

_No response_

### Alternatives Considered

Postgres had [compression implemented in their SSL transport](https://www.postgresql.org/docs/15/libpq-connect.html#LIBPQ-CONNECT-SSLCOMPRESSION), but it got retired mainly because the underlying SSL library has an insecure implementation.

### Additional Details

_No response_