Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vSdhE-002S7W-2L for pgsql-admin@arkaria.postgresql.org; Mon, 08 Dec 2025 16:02:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vSdhD-000PL6-13 for pgsql-admin@arkaria.postgresql.org; Mon, 08 Dec 2025 16:02:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vSdhC-000PKw-2L for pgsql-admin@lists.postgresql.org; Mon, 08 Dec 2025 16:02:43 +0000 Received: from mail-oo1-xc2a.google.com ([2607:f8b0:4864:20::c2a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vSdhA-003mU7-1U for pgsql-admin@lists.postgresql.org; Mon, 08 Dec 2025 16:02:42 +0000 Received: by mail-oo1-xc2a.google.com with SMTP id 006d021491bc7-6596897c2b5so2673616eaf.0 for ; Mon, 08 Dec 2025 08:02:41 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1765209760; x=1765814560; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=h7x12LC7DZ9uAT8BTa2WYg2CBMp7ROrjAYYrPXtqef8=; b=Pg65whE9YNTBmp+/de6p10JdZdQSpIbsS15UlvKr1NjiGBtyQ/qO4CBBbftPBlsf3a RVW93pCFDyMsWIZ3upIexKrG8n5mOCZqXsRiNgOEWL0e0gpuvDlxh0BfLUfZ7o4FFvlG AeDRJiveviUwjzUru/Kab2GpGMMBJ8u+UZAFossUnesCAacibOhzD3raWLUSuiinMgWd iid4bIVdfTUc95OU1oLXqTvXSP8YgG9P5isE2PuMgFR3nP7tNjyRWbz3rTUgnb50XKZU kdNZBUEkMCs19xiDMXPcXB/UYHPt1ReOQC4/9TTkR0AsSARrwJjgysPY4YXO/Jiy62K6 QFfw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1765209760; x=1765814560; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=h7x12LC7DZ9uAT8BTa2WYg2CBMp7ROrjAYYrPXtqef8=; b=aU3xr7IjY6nW167Z+ZrHExf18o6RVAQ0nuEGBD2PMhx0pITBuIM0PjkiMNYEKPUsGw QWLVpAkflVvLExwmAaC8/gJZGKaSUFYi5Cf+5Z/CnhkhrNJ5ryTV2upYOT4IU0HMD1RK rdr5ddYTQCMeYAmwhrDMGqnk3i4aHRWHzvl6pAg5/8CnfzQ7Xm6ALmV7N+1slC7YyHoq cj6uvPVJ/dvoL2bAnd/Jw9jkZLvDosxYLgRh/N5EEwWeZTt6dCnq8iaFwthkzMFPBqdr Tc+ASIFed35dY4W0UDQUMyPQw1sTc/KK9RcrPBLpuBjIDfdnPvMBtFOjmTyATo3WpIn3 N5+g== X-Gm-Message-State: AOJu0YyIBzas7n29B1BLb9uEOqPnwkfxgBHPWN76b8yrGJwEJr1aUowa XC28qzSlkZnoXGKEEJIplyWSMiqgRnxV7AircZnramCd31aQ/PmHwXryIcu1IyhQe6Kr0CB+QF2 rmwknml1z97T8Hj+4ppaDxJ04aO0plPsFAuNJ X-Gm-Gg: ASbGncv9yO+NDKRS4Pam8Hd/+3hE71dKRNwd4PWkt+drifcKT5889/giZY7uyapxhsn +fD9w6gcvD8w0e6FylRXN207WO0oC4pOOpspssDksfj4mu/0G9Jg9Z2GlfUEisHdDkBL6hy7exT RhrhHfRMYW48F5fiJ/FeMzW4mwbP8Yy2Xa4q5CnMdX1fCQUBOcswtbNf8fCI7ztPfYUC/Q+DH3t rl1iRCDtRiH+y/G47TdXZJKvU7vMNFAgbe90rIbKlgHXX1mnfLVV1f1wxRbQbABVf3Z+AfmAdJK f+JI9FcgQQlS+fFZWrT0xZR/oY8YlN27WU7uoSKJ16bsffbwl6KH/m5w6u1lENJjwSZRzG0i X-Google-Smtp-Source: AGHT+IHNtOWiQr33qUdNeIav1P3ioPBS7ykBI61lMSqPek0UJLHYh2ODdL2hsF6gwmYNP4cbhqVGnHHCdImLTL+yGRk= X-Received: by 2002:a05:6820:f00a:b0:659:9a49:8f02 with SMTP id 006d021491bc7-6599a8bf0damr2996206eaf.19.1765209759828; Mon, 08 Dec 2025 08:02:39 -0800 (PST) MIME-Version: 1.0 From: Rakesh Nashine Date: Mon, 8 Dec 2025 21:32:28 +0530 X-Gm-Features: AQt7F2oHGq87-8JOgrFvvw4h7CRmvjfK_IGXqpt5mWEsnZluy-kXxF9UeTM6pKs Message-ID: Subject: WithHold Cursor issue post migration to Azure To: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000b05099064572ec67" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b05099064572ec67 Content-Type: text/plain; charset="UTF-8" We have recently migrated our postgreSQL DB to Azure with 12.3. version, alongside we also migrated our application to newild build RHEL9 , but we are facing withhold cursor issue and performance issue . Below are the details .. I need expertise on how to resolve this .. *Servers* *ODBC Driver Version (psqlODBC)* *PostgreSQL client libs version* *PostgreSQL DB Verison* *HOSTAPP007 (Azure)* postgresql*12*-odbc-*17.00*.0002-1PGDG.rhel9.x86_64 postgresql*12*-libs-*12.22*-1PGDG.rhel9.x86_64 *DBHOSTDB005* postgresql*12*-libs-*12.3*-1PGDG.rhel7.x86_64 psql (PostgreSQL) *12.3* *HOSTAPP002 (Re-hosted)* postgresql*12*-odbc-*12.01*.0000-1PGDG.rhel7.x86_64 postgresql*12*-libs-*12.3*-5PGDG.rhel7.x86_64 *DBHOSTDB001* postgresql*12*-libs-*12.3*-1PGDG.rhel7.x86_64 psql (PostgreSQL) *12.3* *Azure RHEL version:* NAME="Red Hat Enterprise Linux" VERSION="9.4 (Plow)" ID="rhel" ID_LIKE="fedora" VERSION_ID="9.4" PLATFORM_ID="platform:el9" PRETTY_NAME="Red Hat Enterprise Linux 9.4 (Plow)" ANSI_COLOR="0;31" LOGO="fedora-logo-icon" CPE_NAME="cpe:/o:redhat:enterprise_linux:9::baseos" REDHAT_BUGZILLA_PRODUCT="Red Hat Enterprise Linux 9" REDHAT_BUGZILLA_PRODUCT_VERSION=9.4 REDHAT_SUPPORT_PRODUCT="Red Hat Enterprise Linux" REDHAT_SUPPORT_PRODUCT_VERSION="9.4" *On-prem RHEL Version:* NAME="Red Hat Enterprise Linux Server" VERSION="7.9 (Maipo)" ID="rhel" ID_LIKE="fedora" VARIANT="Server" VARIANT_ID="server" VERSION_ID="7.9" PRETTY_NAME="Red Hat Enterprise Linux Server 7.9 (Maipo)" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:redhat:enterprise_linux:7.9:GA:server" REDHAT_BUGZILLA_PRODUCT="Red Hat Enterprise Linux 7" REDHAT_BUGZILLA_PRODUCT_VERSION=7.9 REDHAT_SUPPORT_PRODUCT="Red Hat Enterprise Linux" REDHAT_SUPPORT_PRODUCT_VERSION="7.9" -- Thanks & Regards RN --000000000000b05099064572ec67 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
We have recently migrated our postgreSQL=C2=A0DB to A= zure with 12.3. version, alongside we also migrated our application to newi= ld build RHEL9 , but we are facing withhold cursor issue and performance is= sue . Below are the details .. I need expertise on how to resolve=C2=A0this= ..=C2=A0

Servers

ODBC Driver Version (ps= qlODBC)

PostgreSQL client libs = version

PostgreSQL DB Verison

HOSTAPP007 (Azure)

postgresql12-odbc-17.00.0002-1PGDG.rhel9.x86_64

postgresql12-libs-12.22-1PG= DG.rhel9.x86_64

=C2=A0

DBHOSTDB005

=C2=A0

postgresql12-libs-12.3-1PGD= G.rhel7.x86_64

psql (PostgreSQL) 12.3

HOSTAPP002 =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0(Re-hos= ted)

postgresql12-odbc-12.01.0000-1PGDG.rhel7.x86_64

postgresql12-libs-12.3-5PGD= G.rhel7.x86_64

=C2=A0

DBHOSTDB001

=C2=A0

postgresql12-libs-12.3-1PGD= G.rhel7.x86_64

psql (PostgreSQL) 12.3

Azure RHEL version:

NAME=3D"Red Hat Enterprise Linux"

VERSION=3D"9.4 (Plow)"

ID=3D"rhel"

ID_LIKE=3D"fedora"

VERSION_ID=3D"9.4"

PLATFORM_ID=3D"platform:el9"

PRETTY_NAME=3D"Red Hat Enterprise Linux 9.4 (Plow)"

ANSI_COLOR=3D"0;31"

LOGO=3D"fedora-logo-icon"

CPE_NAME=3D"cpe:/o:redhat:enterprise= _linux:9::baseos"


=C2=A0

REDHAT_BUGZILLA_PRODUCT=3D"Red Hat Enterprise Linux 9"

REDHAT_BUGZILLA_PRODUCT_VERSION=3D9.4

REDHAT_SUPPORT_PRODUCT=3D"Red Hat Enterprise Linux"

REDHAT_SUPPORT_PRODUCT_VERSION=3D"9.= 4"


On-prem RHEL Version:

=C2=A0

NAME=3D"Red Hat Enterprise Linux Server"

VERSION=3D"7.9 (Maipo)"

ID=3D"rhel"

ID_LIKE=3D"fedora"

VARIANT=3D"Server"

VARIANT_ID=3D"server"

VERSION_ID=3D"7.9"

PRETTY_NAME=3D"Red Hat Enterprise Linux Server 7.9 (Maipo)"

ANSI_COLOR=3D"0;31"

CPE_NAME=3D"cpe:/o:redhat:enterprise= _linux:7.9:GA:server"


=C2=A0

REDHAT_BUGZILLA_PRODUCT=3D"Red Hat Enterprise Linux 7"

REDHAT_BUGZILLA_PRODUCT_VERSION=3D7.9

REDHAT_SUPPORT_PRODUCT=3D"Red Hat Enterprise Linux"

REDHAT_SUPPORT_PRODUCT_VERSION=3D"7.= 9"


--
Thanks & Regards
RN
--000000000000b05099064572ec67--