| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | github(at)cquest(dot)org |
| Subject: | BUG #16183: PREPARED STATEMENT slowed down by jit |
| Date: | 2020-01-02 10:48:17 |
| Message-ID: | 16183-64843a4ebc44d9d2@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 16183
Logged by: Christian Quest
Email address: github(at)cquest(dot)org
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2020-01-02 14:07:03 | Re: BUG #16182: Error in logs from "renaming temporary statistics" |
| Previous Message | Dhanraj Acharya | 2020-01-02 08:51:30 | Re: PostgreSQL Installation Error |