pg_trgm similarity threshold
Hi all!
I'm wondering if someone could help me with this issue: https://www.answeroverflow.com/m/1353927769792184330 I have a similar question where I can't seem to set the similarity threshold on my connection. We're on the Launch plan.
I'm wondering if someone could help me with this issue: https://www.answeroverflow.com/m/1353927769792184330 I have a similar question where I can't seem to set the similarity threshold on my connection. We're on the Launch plan.
Hi,
Is there a way to permanently set pg_trgm.similarity_threshold from the default 0.3 to 0.5 in Neon? This query does just that in our local db:
ALTER SYSTEM SET pg_trgm.similarity_threshold = 0.5
But in Neon, when we run:
SHOW pg_trgm.similarity_threshold;
We expect to see a value, but we get the error in the screenshot instead. Any idea...
Is there a way to permanently set pg_trgm.similarity_threshold from the default 0.3 to 0.5 in Neon? This query does just that in our local db:
ALTER SYSTEM SET pg_trgm.similarity_threshold = 0.5
But in Neon, when we run:
SHOW pg_trgm.similarity_threshold;
We expect to see a value, but we get the error in the screenshot instead. Any idea...
