IssueTracker

This will create a feature request which anybody can view and comment on.

Please describe your requested enhancement. Good feature requests will solve common problems or enable new use cases.

We request the addition of support for pg_squeeze version 1.5.1 in Cloud SQL for PostgreSQL 16. Currently, Cloud SQL supports pg_squeeze 1.5.0, but this version is not compatible with PostgreSQL 16. Upgrading to pg_squeeze 1.5.1 would enable users of PostgreSQL 16 to utilize this important extension for performance optimization.


What you would like to accomplish:
Enable users of Cloud SQL for PostgreSQL 16 to use the pg_squeeze extension for table compression and performance improvement. This would allow customers to address performance issues related to table bloat without having to downgrade their PostgreSQL version.

How this might work:
Support pg_squeeze extension in Cloud SQL for Postgres 16 instance.

Currently, users of PostgreSQL 16 in Cloud SQL have no built-in alternative for table compression comparable to pg_squeeze. The only workaround is to downgrade to an earlier version of PostgreSQL, which is not ideal as it prevents users from leveraging the latest features and improvements in PostgreSQL 16.

 Other information (workarounds you have tried, documentation consulted, etc):
- Consulted Cloud SQL documentation on supported extensions: https://cloud.google.com/sql/docs/postgres/extensions
- Verified that pg_squeeze not compatible with PostgreSQL 16 according to the pg_squeeze project documentation[1]
- Currently, there are no viable workarounds for users who need both PostgreSQL 16 and table compression capabilities in Cloud SQL.
[1]https://cloud.google.com/sql/docs/postgres/extensions