Looks like we can confirm that the jit disable fixed the problem, because since yesterday when I disabled jit, the database did not restarted again, and before it the database was restarting at least once per hour.
I don't think it will cause too much impact in our use case having it disabled, so, if you need anything else that could help the analyses to find the bug feel free to let me know and I can grab the logs or whatever needed.
Thanks y'all
On Mon, Nov 7, 2022 at 8:05 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Willian Colognesi <willian_colognesi@xxxxxxxxxxx> writes:
> There is no llvm installed on ubuntu server, postgresql was installed via
> apt package `apt install postgresql-14`
If there's no LLVM around, then disabling JIT wouldn't do anything,
because it depends on LLVM to compile code.
We should perhaps wait awhile to see if that really fixed it.
regards, tom lane
Willian Cezar de O. Colognesi
Systems Analysis Specialist, Trimble Transportation Brazil
