I am using a prometheus exporter: https://github.com/prometheus-community/postgres_exporter/ Turning JIT off definitely made a big difference to all our environments. When using JIT it causes OOM on postgres server after a few days. Adding jit=off resolved the issue. I have tested this now for several weeks and memory usage stays stable when jit=off. You can see the related issue here: https://github.com/prometheus-community/postgres_exporter/issues/694
On Thu, 3 Nov 2022 at 16:01, Tom Lane <t...@sss.pgh.pa.us> wrote: > Stefan Badenhorst <stefan.badenho...@mi-c3.com> writes: > > This is working: > > postgresql://USERNAME:PASSWORD@server > > :5432/the_database?sslmode=disable&jit=off > > Again, not for me: > > $ psql 'postgresql://postgres@localhost:5432/mydb?sslmode=disable&jit=off' > psql: error: invalid URI query parameter: "jit" > > I suspect something in your client environment is stripping off the &... > stuff. > > regards, tom lane > -- Email Disclaimer This email is proprietary to MI-C3 and is intended only for the person to whom it is addressed. It may contain confidential and privileged information. If you have received this email in error, please notify the sender and delete this email, which must not be copied, distributed or disclosed to any other person. Any views or opinions presented are solely those of the author and do not necessarily represent those of MI-C3. Since this communication was affected via email, MI-C3 cannot guarantee that it is secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. MI-C3 does not accept liability for any errors or omissions in the contents of this message or for any damage resulting from the opening of this message should it contain a virus.