Menu
Is there any internal method in postgresql to enable data compression over psql connection over tcp socket.
I can also use some other method that are not internal to postgresql, such as ssh compression or any other vpn compression. However, this may increase complexity.
Regards,
941
PostgreSQL uses a fixed page size (commonly 8 kB), and does not allow tuples to span multiple pages. Therefore, it is not possible to store very large field values directly. To overcome this limitation, large field values are compressed and/or broken up into multiple physical rows.
The default connection timeout limit to PostgreSQL data sources is 30 seconds.
It seems that starting with postgresql 9.2 there is an sslcompression option that defaults to true. However it requires that the used openssl library is build with zlib support to work. For instance the openssl binaries in the windows enterprise DB installers do not have this support. Also both sides have ofcourse to support it!
77
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
