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.
Set pg_trgm.similarity_threshold not working? - Neon
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...
1 Reply
like-gold•19h ago
Hey!
Indeed because we are a managed service we don't allow ALTER SYSTEM.
However, you can still use
SET pg_trgm.similarity_threshold = 0.5 per session.