Monday, November 9, 2020

[google-cloud-sql-discuss] Re: Customize Postgres pg_trgm.similarity_threshold

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.
On Monday, November 9, 2020 at 12:44:24 PM UTC-5 max...@naeka.fr wrote:

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.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/a4827da2-21f2-445a-b12c-c43842bc082en%40googlegroups.com.

No comments:

Post a Comment