Support compression_algorithms

[tom10271]

We are running SQL with result of a few MB. This is pretty large without compression.

CREATE SERVER my_rds FOREIGN DATA WRAPPER mysql_fdw OPTIONS (host 'our-rds.some-region.rds.amazonaws.com', port '3306', character_set 'utf8', compression_algorithms 'zlib,zstd');

https://aws.amazon.com/blogs/database/reduce-network-transfer-time-with-connection-compression-in-amazon-rds-for-mysql-and-amazon-rds-for-mariadb/

Thank you for helping

[surajkharage19]

Thank you @tom10271 for your message.

If I understand correctly, you are looking for a connection compression feature in mysql_fdw and that feature helps when network bandwidth is a constraint and result sets are large.

Currently, mysql_fdw does not have this feature. We will consider this feature for implementation but please note that we don't have an immediate plan to do the same.

If you are interested, you can submit the pull request for the same and we will review that and take it further.

Thank you for your understanding.