| 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
| 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 |