pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Abraham, Danny <danny_abraham@bmc.com>
To: psql-performance <pgsql-performance@postgresql.org>
Subject: Re: Performance down with JDBC 42
Date: Sat, 04 Nov 2023 22:07:19 +0100
Message-ID: <fbfaf1a0a5a83d35971b7d77c5cbf64d72375dc4.camel@cybertec.at> (raw)
In-Reply-To: <PH0PR02MB744665C3C2C73A828B42D9988EA4A@PH0PR02MB7446.namprd02.prod.outlook.com>
References: <5c1179bb-240b-4c1c-b4b3-2a24868e44bc@stiltsoft.com>
	<1570249.1697228785@sss.pgh.pa.us>
	<dd874d42-ad02-48a6-82db-5666f1ee0ec1@stiltsoft.com>
	<3153246.1697661350@sss.pgh.pa.us>
	<e9d503cb-efeb-43d3-952e-f517e4d24302@stiltsoft.com>
	<1157086.1698329377@sss.pgh.pa.us>
	<6c888a16-b206-4817-b5ca-9e09b904edde@stiltsoft.com>
	<DM6PR03MB433237820C534143711439B2FAA0A@DM6PR03MB4332.namprd03.prod.outlook.com>
	<2641105.1698788712@sss.pgh.pa.us>
	<PH0PR02MB744665C3C2C73A828B42D9988EA4A@PH0PR02MB7446.namprd02.prod.outlook.com>

On Sat, 2023-11-04 at 19:08 +0000, Abraham, Danny wrote:
> Asking for help with a JDBC related issue.
> Environment: Linux 7.9 PG 14.9 , very busy PG Server.
> 
> A big query - 3 unions and about 10 joins runs :
> - 70ms on psql , DBeaver with JDBC 42  and  in our Server using old JDBC 9.2
> - 2500 ms in our Server using new JDBC 42 driver. ( and  this is running many times) 
> 
> Question: Is there a structured way to identify optimization setup ( Planner Method s ) changes?
> Are there any known changes specific to JDBC 42. 

What I would do is enable auto_explain and look at the execution plan
when the statement is run by the JDBC driver.  Then you can compare the
execution plans and spot the difference.

Yours,
Laurenz Albe





view thread (10+ messages)  latest in thread

Message-ID: <fbfaf1a0a5a83d35971b7d77c5cbf64d72375dc4.camel@cybertec.at>
Permalink:  ../fbfaf1a0a5a83d35971b7d77c5cbf64d72375dc4.camel@cybertec.at/
Also on:    postgresql.org/message-id/fbfaf1a0a5a83d35971b7d77c5cbf64d72375dc4.camel@cybertec.at

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: laurenz.albe@cybertec.at, danny_abraham@bmc.com
  Subject: Re: Performance down with JDBC 42
  In-Reply-To: <fbfaf1a0a5a83d35971b7d77c5cbf64d72375dc4.camel@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox