Customize Postgres pg_trgm.similarity_threshold

[Maxime Gaillard]

Hello all,

On a Postgres (currently using pg12) instance, we need to update the `pg_trgm.similarity_threshold` setting.

On Postgres with root access we could set it with : `ALTER SYSTEM SET pg_trgm.similarity_threshold = 0.1;` or by setting it in the `postgresql.conf` file.

On CloudSQL we can't set it these ways, and neither through the database flags as it isn’t supported (yet?): https://cloud.google.com/sql/docs/postgres/flags

How can we do it? Thx.

[Kevin (Cloud Platform Support)]

Hello,

In order to enable this configuration to be set through a database flag, I have submitted a feature request for this particular feature. This feature request has been forwarded to the Cloud SQL specialist team so that they may evaluate it. Note that there are no ETAs or guarantees of implementation for feature requests. All communication regarding this feature request is to be done on the corresponding public tracker.

As of now, I am currently unaware of any ways to set this particular setting in the Cloud SQL environment, however rest assured that as this feature has been requested, we will be looking into this particular feature.