Set pg_trgm.similarity_threshold not working?
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 how to set it to be 0.5 permanently? The neon docs hard code > 0.3, but we're trying to set it on the DB level. Is that possible?
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 how to set it to be 0.5 permanently? The neon docs hard code > 0.3, but we're trying to set it on the DB level. Is that possible?
