Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1ldeGP-0003zj-3r
	for pgsql-performance@arkaria.postgresql.org; Mon, 03 May 2021 19:29:53 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1ldeGO-0006LV-2Q
	for pgsql-performance@arkaria.postgresql.org; Mon, 03 May 2021 19:29:52 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <cdalxndr@yahoo.com>)
	id 1ldI2C-0002Qh-Fq
	for pgsql-performance@lists.postgresql.org; Sun, 02 May 2021 19:45:44 +0000
Received: from sonic308-9.consmr.mail.ne1.yahoo.com ([66.163.187.32])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <cdalxndr@yahoo.com>)
	id 1ldI26-000419-Cy
	for pgsql-performance@postgresql.org; Sun, 02 May 2021 19:45:44 +0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048;
 t=1619984734; bh=iaJCd1fdvV4WV7l+RQNDGWPZWmxz/wjgXN149T/uazk=;
 h=From:Subject:To:Date:References:From:Subject:Reply-To;
 b=AhT71CyWFJhyH8x9xi7amCTMl2oYaAynvP+VI9pDYhDd2IxvPzVO0cSPY/sYtC6w/xAGyrhxPBG5YszjGb9kuXdG0z/Sg+D8XqfKyov4Y/me6p4TabB9nRpQuhMqaKccja82BZJqXqDy+fexXromlkm36pes7nL2YRlsMRiBzm8/dFZpVvkNc57HVYnKHuEmZGCIa5o/ElOzP/xd+A5uiBmrBsrlwNH84naeC0Q3wcnAkPwCzNy3TkW5tr9LmZklE/rKyjOM7uIB7BNYHPIXe+C+QMvAWro9DG06G1J90YJ50VCPEekiTPJsDxG4bmgCG/pOtPFKyhXPmQGFfyRNwA==
X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048;
 t=1619984734; bh=WpejBKdmdGkb5bqp1KdaPdBHctSVFei5phlxSgYQk3T=;
 h=X-Sonic-MF:From:Subject:To:Date:From:Subject;
 b=FSkTMnRuy8B3FYFuqg8cchtZWiS2FKFMGMl5x6zq7l2Ddpu6P4SczpZvlssO9lIiocsWqGz6qcAy+ezLETIrUMWVM4q6Vdva1OI2UTVq08pTA8WbmQZKNTZmHsMOwTMKstD5WEmkr0GCxfsKDMpDe5AwdUZIj4DbehmgLVw5uZbnGI+WZzVH1YCSoYeexBuVqgu6Qk4uAhWvCE1iymRfqgb4nr5KRwg6xqLe3457hHyfInUOFCsFwJRXxucK8Gz2rtsZqFHx+buqAJ2uIUx5JvFH1aRtfPmGkh3OEHVFKeZyy8mjR/rFd7MXinF+ZvHBavoxeor4uDhl60Zo096pqQ==
X-YMail-OSG: GU3wlUsVM1lQ8CBuC20VjnTtXdMtgPrfWBUucpwksJdzrCchX1nBS1Nx_usiI8l
 IDnHUFip.Nu233hww9TBCPWpibEr7zO0A_7iNkvGM_FcCXLFUvmz8UwwLqIG9CKcUwFeYgjiy7ce
 jHH.Y_wN_zqJgwEPkLZqgobDQ4U9VNnn1sxx2qBuMkSX64Ii8wikk3iKjX4cRGjkpcvApEAzE3k9
 1W4cmXx_pwxW7gPXe8Qek2RyGxrrwwUpjUQ9L2EWqXy7pONuELruB8vRqNJMIQM0.O4cZm..LeXv
 p5hao0ND3qGnczpShUWLNCcTc2_6.Hel8rvbzqB.P0hHB_W6s7RHkY4Awxr8CnjQcdkD8tew8C3K
 qrcd4MOhYae4xfNbIkf4HUlTWthdhXcUIxqeppBmUQhIYpFvyRESRpoU6Xt4YwDv3EbaW_U79Duz
 QbEbLwa0NBgb4eurf7nba2lWhGz3GS.lJn68xEcxetzt4.UVRqhOHMtiwrdumiBI_njYcmm7eVSn
 ItutILFcs6FK0GBOzfnVXV3RnEyU25rEG_eokTUODp7wjIaJsdw5WGPMn79FiiPEOwTdetjEpFWv
 QQRLNdZjuYRYjxzwHiBE9ExBcytaLDCMy44TTNw4mnaw8fIV9LmpZxTpKqpI3V0r34D6akN87vtB
 kbc2PAAeY6JKpvmxXOizVDmMkZnBYfgnGiXp1q9UpbB_D94al79esffMClnk4eEBKNhckPy9QMAO
 vpTFGE97mNl6.jW3h1CxjVch1VNLHcITeg_MR0LkhrF8J.3O5qDN03b55EtiVb834VXe.yLJnKTB
 ajfAqr5DtBU9IzYb5rEzS9B6f9MkUMAkmGEsNhOQ8TxmoS18rU8nscya.nbxmyDh5yEs7PfZjVVC
 Pw1W3jbJKbSKAhcHx7IL8l8WjYF6f99uOFIsw3x_Vzsrht8GRpeEUtGoUtfyGmeGLfrU2VP5ZQAA
 uX.31qxSgn5hNq3whrUvkRxzoSnSbOe5lsrKTsBimntss3G9QP3feTHdkt.ckdV2ZA6.X61u9f2g
 8Jema4E.WpHqRQ7NXmhKwIaY3nWAvJzZUScHlQ_lJHjn1AgU5qGge94PWGhMcLe593iZpb1lBnc_
 e5cOCLSsesvmKY.s2qYIwFx60NMIf7HM6ytoUk_bm0okrvIoqYQO.RqH8zkYhcU49EEClnaFOihm
 kjtNGqPOwPXpYDs9sFPXrEP_F7sTV48mA27ByL2HVtCZZaGLzTCZxw67GP0xC.vRUXdeVf9K3RY_
 DAui2bzt_IwBIUUf9a8y9M3AGKamNjSYBYngvlkX6TnQfZgA0wMmeiUQyhJBOdPUWXT5LbYxHAqm
 WTte1ailuOJhCN_337dKgfS7C1R7sFGDsJRDmJscwfWgq4mtTxKrfUOnRaBKfg4sHylWqlV8bdxy
 Vla_6lmupZHwEH9UWhCtO1bLDO5kVhNISTAvWOGbCz2CpGmcEfHmJ5UhbEG0AXr3eLyjS10jinLZ
 ntRCTqgH09TlSw_H3o1kKtSBYAzb7LMURrex5loBXiOv6J_Ag__bx9pZbIHVmGepalHKHBFs9KG.
 vOdzSShfE6CLSvRxlvP03pliOQfkgUB6aNR80VVXDvlNuCgCLZ36f7Kw1aNAeUL7fteJTpuMyBjc
 e2o2cI9kJo1DdkQWtz57ekmDLgI41809yKmEyTt4klPP4ymNmIvbmERJByOq9i3PYtfjlyljCMpp
 z5ZiQ9OCGExMhGR29yhJrwD6lzZlwh8bHRMwl34SO.b__HE._OCirpW3gqZnvqIdzhPCGA5icPPm
 lBH8KjXDcKatHCQDuJx9KkSbI0CpPrEkD36263amgpdkCTZdpsZTY4OsW58qGDGqtwyK2QkZqHTD
 _M_n9zsAKe.WcfXzr5ZWUpOmQmmVDJ.UMRESFPYizAB5WHlesi.CWdZ1p1V.Svpofg._ghHRxLIe
 3Was7ugilUh_VfSEg1CnJjY9bKBTy7yLXgU3qSADcmisydoGCmIN07hS7_S4dtgW0yfL.KfdsvRl
 5NncLUgcS0nCRcoE6F.mm0POfZd3fbaWv3jKxr3DRMfLJwJKba5sSZrz5tb5k6SQZm_nXILygrnR
 ji3Asu4wW48cRbJeglDa9VHSM5B9uhlMr30Im2cGJJDRY7hT_YwbIshtZyhWa.cL0nMggxsHha3Q
 TbspBC.PuJZRrodsJFq9zDJlSmLaGwd44zKL977dycpqLKERTy4szCL6YNRCvL2.sNWOKuN30eVk
 z7_l9OMrZM4wW9jPhia1kjXw8gvgk5yGWrrohvw0hsqx3GdOJbCjA9ubGS_n8sOZsFD5nEuVS.pS
 5cqK1KL8Kqw40r427jC3g1lvTKVcQsmS8kZlMPsI33vxanTZ7DcNHuZ9220p1jRE03t2Dl.ajPPW
 0yn6s.H8aFuxe0zNAUPV1ApVzlIC9aqgh
X-Sonic-MF: <cdalxndr@yahoo.com>
Received: from sonic.gate.mail.ne1.yahoo.com by
 sonic308.consmr.mail.ne1.yahoo.com with HTTP; Sun, 2 May 2021 19:45:34 +0000
Received: by kubenode512.mail-prod1.omega.ir2.yahoo.com (VZM Hermes SMTP
 Server) with ESMTPA ID 5f45f103d6d2cbfb641f6542d17831f7;
          Sun, 02 May 2021 19:45:29 +0000 (UTC)
Content-Type: multipart/alternative;
 boundary="----sinikael-?=_1-16199847266140.407986414129311"
From: Alex <cdalxndr@yahoo.com>
Subject: 15x slower PreparedStatement vs raw query
To: pgsql-performance@postgresql.org
User-Agent: Desktop
Message-Id: <3f8c88d8a6ef9.d82fa04cf610d@yahoo.com>
Content-Transfer-Encoding: quoted-printable
Date: Sun, 02 May 2021 19:45:26 +0000
MIME-Version: 1.0
References: <3f8c88d8a6ef9.d82fa04cf610d.ref@yahoo.com>
X-Mailer: WebService/1.1.18138
 mail.backend.jedi.jws.acl:role.jedi.acl.token.atz.jws.hermes.yahoo
 Apache-HttpAsyncClient/4.1.4 (Java/16)
Content-Length: 1169
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Archived-At: 
 <https://www.postgresql.org/message-id/3f8c88d8a6ef9.d82fa04cf610d%40yahoo.com>
Precedence: bulk

------sinikael-?=_1-16199847266140.407986414129311
Content-Type: text/plain; format=flowed
Content-Transfer-Encoding: 7bit

PreparedStatement: 15s
Raw query with embedded params: 1s
See issue on github with query and explain analyze:
https://github.com/pgjdbc/pgjdbc/issues/2145 
<https://github.com/pgjdbc/pgjdbc/issues/2145> 

------sinikael-?=_1-16199847266140.407986414129311
Content-Type: text/html; format=flowed
Content-Transfer-Encoding: 7bit

<html><head></head><body><div>
                    
     
     
       
         <meta charset="utf-8">
       
       
         <div id="compose-body-wrapper" dir="auto"><div 
dir="auto"><br></div><div dir="auto">PreparedStatement: 15s</div><div 
dir="auto">Raw query with embedded params: 1s</div><div 
dir="auto"><br></div><div dir="auto">See issue on github with query and 
explain analyze:</div><div dir="auto"><a 
href="https://github.com/pgjdbc/pgjdbc/issues/2145" 
target="_blank">https://github.com/pgjdbc/pgjdbc/issues/2145</a></div><div 
dir="auto" id="tmjah_g_1299"><p><br></p></div><br></div>
       
     
   
                   </div></body></html>
------sinikael-?=_1-16199847266140.407986414129311--