Horton

RE: [EXTERNAL] Performance down with JDBC 42

Abraham, Danny <danny_abraham@bmc.com>

View thread
From: "Abraham, Danny" <danny_abraham@bmc.com>
To: Frits Hoogland <frits.hoogland@gmail.com>, David Rowley <dgrowleyml@gmail.com>
Cc: psql-performance <pgsql-performance@postgresql.org>, "Abraham, Danny" <danny_abraham@bmc.com>, "Shivatski, Sagi" <sagi_shivatski@bmc.com>
Date: 2023-11-09T14:00:29Z
Lists: pgsql-performance 
Hi guys,
Thanks for the help.
I was able to recreate the problem , on the same DB, with PSQL only. No JDBC.

A plain run of a complicated query :                      50ms
A prepare and then execute of the same query:   2500ms.

The plans are different, as discussed above. The fast one is using Materialize and Memoize.

Thanks

Danny