RE: [EXTERNAL] Performance down with JDBC 42

From: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
To: Frits Hoogland <frits(dot)hoogland(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: psql-performance <pgsql-performance(at)postgresql(dot)org>, "Abraham, Danny" <danny_abraham(at)bmc(dot)com>, "Shivatski, Sagi" <sagi_shivatski(at)bmc(dot)com>
Subject: RE: [EXTERNAL] Performance down with JDBC 42
Date: 2023-11-09 14:00:29
Message-ID: PH0PR02MB74463AB1493205EAB31B79448EAFA@PH0PR02MB7446.namprd02.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Lincoln Swaine-Moore 2023-11-09 18:00:24 Re: Awkward Join between generate_series and long table
Previous Message Philip Semanchuk 2023-11-09 13:54:36 Re: Awkward Join between generate_series and long table