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 1vT3m0-00C1uu-1r for pgsql-general@arkaria.postgresql.org; Tue, 09 Dec 2025 19:53:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vT3ly-006cVN-1n for pgsql-general@arkaria.postgresql.org; Tue, 09 Dec 2025 19:53:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vT3ly-006cVF-0l for pgsql-general@lists.postgresql.org; Tue, 09 Dec 2025 19:53:22 +0000 Received: from mail-pg1-x531.google.com ([2607:f8b0:4864:20::531]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vT3lw-0046Sk-0Y for pgsql-general@lists.postgresql.org; Tue, 09 Dec 2025 19:53:22 +0000 Received: by mail-pg1-x531.google.com with SMTP id 41be03b00d2f7-bde0f62468cso5975609a12.2 for ; Tue, 09 Dec 2025 11:53:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1765309998; x=1765914798; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=2V2pDggXMvoMNzto9YaSnCCXszbMIIc4/p8iUYtDw00=; b=VNF+9O77XaQ3Bsj2NLfjEemOWHbniNUy2qUcBi3x4YrIv/t5TF9bMRKJNxI5ZFRI0e JLj7mk/xlDqXA5U4j6ijdGDn+/ANs1jDiDiT2oMcIgb4p6qgfjQLOjY2c34oi5PLIli+ ripqaFd4BNhsulzGaDL1YfmE0ctcHowOiNwBAMlOUdCs0Q4LTeT4IMZXCWRVgKzcWrJK 4r/mIqwlOxs+jT3PdJmmq3bnoG4lNYPwZuaYAIctiOid/mxu+vaDfhjNjajFHKn2B5rC 0/ekDhqWY30ZEZpphNq+8CTV/jTBgowJKsG6khMrXB4uIaJaRyPnZ9KPXB1GrQq5e0im ZDfA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1765309998; x=1765914798; 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=2V2pDggXMvoMNzto9YaSnCCXszbMIIc4/p8iUYtDw00=; b=c+jPi8KrHB0mo6NqeNQJVJEyESMNx/reAYb1LxqW3ZUDGhJt+tqGJGyzhbgoRUR4j4 +UY2Hv4WtrhCn0smQsMH/s4+4sRQDv3BzTCbjTB6Cc1jr1XP7KxBQx9FLudMLZOpWihF J/bnSaB8CTqKBq6OKrw2cXKu/juepeSUyGUK4Z9xCVpQG3TyuGhaimTpCXvj3uuZcxk1 t/pYCvqFa1nMwA2A6b/lvtpV3WJXBEawCsz0bIr6WSpwahUyFOLm+msoWxWVElk3rRhy Y1fwSkEoa5c3I+bvRPcfkeunwu4RI4iN7ANM1tEV2YCFzVHicaIrFspsPNKP7kT7bt3C UPVg== X-Gm-Message-State: AOJu0Yz4/V/fqeSgU9T47wobomsh4sOO+WnKLKFFvpUeBSQLH06x4LYl mUk1Biibg8iQ1uoVxfrESK1/CI18t7VQuw2jGhfqf69AgdAIThymwO1pvGrOSyrypPGK+n2LKwe 2ufhcwD4gsGmX12/QUla7MHqAufcBZsZx X-Gm-Gg: AY/fxX6a3x4N6FbDOrt3ixzgR1wR6FNB+kXjd2iVh04GzB5mhiogCDtHwxQc3JR29T9 pfkakfKk2/Tt8J440l+xyDqztrYu3vcfGjvPoOECO1lWya89rVaLATDvV8uDv6SJs77y++40gYk 3M0SwHbr4GVrU/km5d6WNPpfZLbVkv6RbyPhJRKxuznnN9qdcP3JKjprnUPSufYNFjiFdb8krxS cnPuufvle8VBu5fPjuFG4mdGxgxssvYLcfaBc3uAkuLRC/PzAGpIu+2fvotRP+TXXSJPPDjTNSd Ifykko+rQELJtxZffjtKGK4MmaEzHpzvKGU3TA== X-Google-Smtp-Source: AGHT+IGCdokjmMoREa+Kl7TCWchI/0qjSD1Q18dGoJIsB7jyeJnFaVUpSe85F5hiOkIDKgUQKUOFwNHXf4NUHVjGX8w= X-Received: by 2002:a05:7301:d195:b0:2a4:3592:cf5e with SMTP id 5a478bee46e88-2ac05409da3mr116284eec.2.1765309997640; Tue, 09 Dec 2025 11:53:17 -0800 (PST) MIME-Version: 1.0 From: Tzuriel Kahlon Date: Tue, 9 Dec 2025 21:53:06 +0200 X-Gm-Features: AQt7F2pa-yBlYxk1yQYVDi3hJObROQAB7Wv-Va03qcAh80fq-xrHiUwdBQQ5kt0 Message-ID: Subject: Ecpg fetch issue To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000053f1da06458a4350" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000053f1da06458a4350 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hey all , We are using IBM for cobol and connextint postgres db with ecpg the precompiler , problem is when we running cursor against db the prefetch are not set correctly and provide one row each time he approach to db and this decrease the performance significantly if twvle have 100000 rows it take it one by one each run . In procob which is the precompiler of Oracle there are option to set the prefetch to take in each time it approach the db x number of rows you want and this ease the db retrieved and enhance the performance . I know that there is a way to change the setting in the application code, but I want to eliminate touch any code and configure only the ecpg which is the middle between cobol and db. There is anyone from you which encountered same issue? *=D7=91=D7=91=D7=A8=D7=9B=D7=94 * *=D7=A6=D7=95=D7=A8=D7=99=D7=90=D7=9C =D7=9B=D7=97=D7=9C=D7=95=D7=9F * 0523851143 --00000000000053f1da06458a4350 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hey all ,
We are using IBM fo= r cobol and connextint postgres db with ecpg the precompiler , problem is w= hen we running cursor against db the prefetch are not set correctly and pro= vide one row each time he approach to db and this decrease the performance = significantly if twvle have 100000 rows it take it one by one each run .
In procob which is the precompiler of Oracle there are= option to set the prefetch to take in each time it approach the db x numbe= r of rows you want and this ease the db retrieved and enhance the performan= ce .
I know that there is a way to change the settin= g in the application code, but I want to eliminate touch any code and confi= gure only the ecpg which is the middle between cobol and db.
There is anyone from you which encountered same issue?





=D7=91=D7=91= =D7=A8=D7=9B=D7=94=C2=A0
=D7=A6=D7=95=D7=A8=D7=99=D7=90=D7= =9C =D7=9B=D7=97=D7=9C=D7=95=D7=9F=C2=A0
0523851143
--00000000000053f1da06458a4350--