Monday, November 9, 2020

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

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/392d70d7-b9f2-49c0-8c9b-f8e687db5cafn%40googlegroups.com.

No comments:

Post a Comment