Re: BUG #16183: PREPARED STATEMENT slowed down by jit - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: BUG #16183: PREPARED STATEMENT slowed down by jit
Date
Msg-id CAMkU=1zqRyJTAbS1MRDHeF838jH_fu969P--jWMUvjSGw+AUKg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16183: PREPARED STATEMENT slowed down by jit  (Ryan Lambert <ryan@rustprooflabs.com>)
Responses Re: BUG #16183: PREPARED STATEMENT slowed down by jit  (Ryan Lambert <ryan@rustprooflabs.com>)
List pgsql-bugs
On Sun, Jan 5, 2020 at 7:21 PM Ryan Lambert <ryan@rustprooflabs.com> wrote:

I tried applying your original patch and the later patch from that thread to REL_12_STABLE, unfortunately no luck on either.  The original patch errors with:

$ git apply -p1 < array_type_analyze_MCE_V001.patch
error: src/backend/utils/adt/array_typanalyze.c: already exists in working directory

I just use the GNU "patch -p1" command.  I don't  know what "git apply" is up to here, and the error message isn't very informative.

By the way, the patch says "However, there is no histogram to fall back on when the MCE array is NULL", which is a bit of nonsense.  It is ndistinct, not histogram, which the scalar case falls back on when MCV is NULL.  But there isn't an ndistinct for MCE either, so the conclusion is still sound.

Cheers,

Jeff

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #16190: The usage of NULL pointer in refint.c
Next
From: Tom Lane
Date:
Subject: Re: BUG #16122: segfault pg_detoast_datum (datum=0x0) at fmgr.c:1833 numrange query