Good Afternoon and Happy New
We have been working on a rather elusive performance bug.
When are using our provider_search function, a complex function that involves 30 tables. We are able to run the function and return our results using xtuple, psql, or pgadmin, rather quickly in about 1 to 2 secs. However, once we have ran the function 5 times, on the 6th time the function will begin to perform very poorly, causing the results to return in about 3 minutes. This continues until the session is restarted or xtuple is closed.
Any thought about what might be causing our inconsistent performance?
Ubuntu 18.04.5 LTS
CPU: 16 cores 8 threads
31GB effective cache
10GB shared buffers on 1GB large pages
512MB temp buffers
Thanks and Regards,