Re: Failing to allocate memory when I think it shouldn't - Mailing list pgsql-general

From Christoph Moench-Tegeder
Subject Re: Failing to allocate memory when I think it shouldn't
Date
Msg-id ZunS1AP1XiKXtLzw@elch.exwg.net
Whole thread Raw
In response to Re: Failing to allocate memory when I think it shouldn't  (Thomas Ziegler <thomas.ziegler@holmsecurity.com>)
List pgsql-general
Hi,

## Thomas Ziegler (thomas.ziegler@holmsecurity.com):

> Except for pgAudit, I don't have any extensions, so it is probably the
> JIT. I had no idea there was a JIT, even it should have been obvious.
> Thanks for pointing this out!

There is - it even has it's own chapter in the documentation:
https://www.postgresql.org/docs/current/jit.html
Most importantly, you can disable JIT per session ("SET jit=off")
or globally in the configuration file (jit=off, reload is
sufficient) or with any of the other usual configuration mechanisms.
If that fixes your problem, congratulations (and the problem is
somewhere down between bytecode generation and what and how llvm
(in its particular version) generates from that).

> Is the memory the JIT takes limited by 'work_mem' or will it just take
> as much memory as it needs?

The latter.

Regards,
Christoph

-- 
Spare Space



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: load fom csv
Next
From: veem v
Date:
Subject: Re: IO related waits