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?
3 Replies
sensitive-blue•6mo ago
Unfortunately, as a managed service, we currently don't allow ALTER SYSTEM. If you're on a paid plan, you could reach out to support and see if they can set this for you: https://console.neon.tech/app/projects?modal=support
Alternatively, depending on your app or framework, you also might be able to set it as a session init query or run it automatically after establishing a connection.
other-emeraldOP•6mo ago
Thanks Daniel, we're using Laravel Cloud, which is a Neon partner on the PostgresDB. We may need to go the manual in query route in this case most likely then?
sensitive-blue•6mo ago
I think that's your best short-term option. You could submit a request via Laravel Cloud, and they might take it up with our support team, but I don't know what Laravel Cloud's policies are for requests like this.