On Wed, 29 Jul 2020 at 00:26, Scott Ribe wrote:
> But does compilation with JIT enable and LLVM dev tools mean that all the
> LLVM compilation/optimization is built into the PG binaries, or does it
> require LLVM presence on the machine where deployed? And if so, does the
> function take that
> On Jul 27, 2020, at 9:33 PM, Tom Lane wrote:
>
> The general, non-hacker meaning of "jit is enabled" would seem to
> be pretty much what this function is already doing; and for that
> matter, the same can be said for "JIT compilation is available".
> We need something that's less
> On Jul 27, 2020, at 6:04 PM, David Rowley wrote:
>
> "returns true if jit is enabled and JIT compilation is available in
> this session (see Chapter 31)."
That is clearer. I didn't submit a suggestion myself because I'm not clear on
the actual circumstances. I know it won't be available if:
On Tue, 28 Jul 2020 at 15:55, David Rowley wrote:
>
> On Tue, 28 Jul 2020 at 15:33, Tom Lane wrote:
> >
> > David Rowley writes:
> > > Maybe this would be better?
> >
> > > "returns true if jit is enabled and JIT compilation is available in
> > > this session (see Chapter 31)."
> >
> > The
On Tue, 28 Jul 2020 at 15:33, Tom Lane wrote:
>
> David Rowley writes:
> > Maybe this would be better?
>
> > "returns true if jit is enabled and JIT compilation is available in
> > this session (see Chapter 31)."
>
> The general, non-hacker meaning of "jit is enabled" would seem to
> be pretty
David Rowley writes:
> Maybe this would be better?
> "returns true if jit is enabled and JIT compilation is available in
> this session (see Chapter 31)."
The general, non-hacker meaning of "jit is enabled" would seem to
be pretty much what this function is already doing; and for that
matter,
On Tue, 28 Jul 2020 at 04:18, Scott Ribe wrote:
>
> > On Jul 25, 2020, at 8:02 AM, Christoph Moench-Tegeder
> > wrote:
> > pg_jit_available() boolean is JIT compilation available in this session
> >
> > https://www.postgresql.org/docs/12/functions-info.html
>
> Thanks, that seems to be
> On Jul 25, 2020, at 8:02 AM, Christoph Moench-Tegeder
> wrote:
>
> ## Scott Ribe (scott_r...@elevated-dev.com):
>
>> So JIT is enabled in your conf, how can you tell from within a client
>> session whether it's actually available (PG compiled with it and
>> compiler available)?
>
>
> On Jul 25, 2020, at 8:21 AM, Pavel Stehule wrote:
>
>
>
> so 25. 7. 2020 v 14:04 odesílatel Scott Ribe
> napsal:
> > On Jul 24, 2020, at 9:55 PM, Pavel Stehule wrote:
> >
> > SELECT * FROM pg_config;
>
> That doesn't tell me whether or not it can actually be used.
>
> It shows if
## Scott Ribe (scott_r...@elevated-dev.com):
> So JIT is enabled in your conf, how can you tell from within a client
> session whether it's actually available (PG compiled with it and
> compiler available)?
pg_jit_available() boolean is JIT compilation available in this session
so 25. 7. 2020 v 14:33 odesílatel Scott Ribe
napsal:
> > On Jul 25, 2020, at 6:21 AM, Pavel Stehule
> wrote:
> >
> > It shows if Postgres was compiled with JIT support.
> >
> > When you run EXPLAIN ANALYZE SELECT ... then you can see info about JIT
> overhead. If you don't see notices about JIT
> On Jul 25, 2020, at 6:21 AM, Pavel Stehule wrote:
>
> It shows if Postgres was compiled with JIT support.
>
> When you run EXPLAIN ANALYZE SELECT ... then you can see info about JIT
> overhead. If you don't see notices about JIT in EXPLAIN, then JIT was not
> used.
The presence of "jit =
so 25. 7. 2020 v 14:04 odesílatel Scott Ribe
napsal:
> > On Jul 24, 2020, at 9:55 PM, Pavel Stehule
> wrote:
> >
> > SELECT * FROM pg_config;
>
> That doesn't tell me whether or not it can actually be used.
>
It shows if Postgres was compiled with JIT support.
When you run EXPLAIN ANALYZE
> On Jul 24, 2020, at 9:55 PM, Pavel Stehule wrote:
>
> SELECT * FROM pg_config;
That doesn't tell me whether or not it can actually be used.
so 25. 7. 2020 v 0:49 odesílatel Scott Ribe
napsal:
> So JIT is enabled in your conf, how can you tell from within a client
> session whether it's actually available (PG compiled with it and compiler
> available)?
>
> (In the other discussion I started, doing a dump and import of just the
>
So JIT is enabled in your conf, how can you tell from within a client session
whether it's actually available (PG compiled with it and compiler available)?
(In the other discussion I started, doing a dump and import of just the tables
involved, onto a system where JIT was inadvertently not
16 matches
Mail list logo