PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16183
PG Version12.1
OSUbuntu 18.04
Opened2020-01-02 10:48:17+00
Reported byChristian Quest
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16183
Logged by:          Christian Quest
Email address:      (redacted)
PostgreSQL version: 12.1
Operating system:   Ubuntu 18.04
Description:        

I'm running several OpenStreetMap map rendering servers. They are all based
on PG/postgis.
After an upgrade from v10 to 12, the usual update process took 10x more time
than it used to.

After digging a few days, it appear that the default jit=on is the cause.

The update tool (osm2pgsql) makes heavy use of PREPARED statements. Could
there be a bug in jit+PREPARED causing the statement to be recompiled on
each execute ?

The other side of the issue is described here:
https://github.com/openstreetmap/osm2pgsql/issues/1045

Messages

DateAuthorSubject
2020-01-02 10:48:17+00PG Bug reporting formBUG #16183: PREPARED STATEMENT slowed down by jit
2020-01-02 18:00:20+00Jeff JanesRe: BUG #16183: PREPARED STATEMENT slowed down by jit
2020-01-02 21:29:31+00Christian QuestRe: BUG #16183: PREPARED STATEMENT slowed down by jit
2020-01-02 22:17:36+00Andres FreundRe: BUG #16183: PREPARED STATEMENT slowed down by jit
2020-01-03 14:50:33+00Jeff JanesRe: BUG #16183: PREPARED STATEMENT slowed down by jit
2020-01-03 19:02:18+00Christian QuestRe: BUG #16183: PREPARED STATEMENT slowed down by jit
2020-01-06 00:21:20+00Ryan LambertRe: BUG #16183: PREPARED STATEMENT slowed down by jit
2020-01-06 17:50:48+00Jeff JanesRe: BUG #16183: PREPARED STATEMENT slowed down by jit
2020-01-13 00:37:33+00Ryan LambertRe: BUG #16183: PREPARED STATEMENT slowed down by jit