Date: Thu, 13 Jun 2024 07:11:53 +0000 (UTC)
From: Chandy G <vgchandru@yahoo.com>
To: 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>, 
	Shammat <shammat@gmx.net>
Message-ID: <1777138388.3406832.1718262713257@mail.yahoo.com>
In-Reply-To: <eff64ce4-b6c5-4fb4-a45a-b3e30f29d6ef@gmx.net>
References: <1204595253.3110982.1718178463166.ref@mail.yahoo.com> <1204595253.3110982.1718178463166@mail.yahoo.com> <eff64ce4-b6c5-4fb4-a45a-b3e30f29d6ef@gmx.net>
Subject: Re: postgres table statistics
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_3406831_664669539.1718262713256"
Content-Length: 2972
Archived-At: <https://www.postgresql.org/message-id/1777138388.3406832.1718262713257%40mail.yahoo.com>
Precedence: bulk

------=_Part_3406831_664669539.1718262713256
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

 Thanks Shammat! Seems to fit the bill, Will give it a try.

    On Wednesday, 12 June, 2024 at 07:44:27 am GMT-7, Shammat <shammat@gmx.=
net> wrote: =20
=20
=20
Chandy G schrieb am 12.06.2024 um 09:47:
> Eventhough pg jdbc driver=C2=A0 provides a way to set fetch size to tune
> the driver to achieve better throughput, the JVM fails at the driver
> level when records of large size (say 200mb each) flows through.
> this forces to reduce the fetch size (if were to operate at a fixed
> Xmx setting of client jvm).


Did you try the driver's "adaptive fetch" feature?


https://jdbc.postgresql.org/documentation/use/#connection-parameters


 =20
------=_Part_3406831_664669539.1718262713256
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"ydp93e2f4d6yahoo-style-wrap" style=
=3D"font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px=
;"><div></div>
        <div dir=3D"ltr" data-setdir=3D"false">Thanks Shammat! Seems to fit=
 the bill, Will give it a try.<br></div><div><br></div>
       =20
        </div><div id=3D"ydp55e06c24yahoo_quoted_8866090155" class=3D"ydp55=
e06c24yahoo_quoted">
            <div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
               =20
                <div>
                        On Wednesday, 12 June, 2024 at 07:44:27 am GMT-7, S=
hammat &lt;shammat@gmx.net&gt; wrote:
                    </div>
                    <div><br></div>
                    <div><br></div>
               =20
               =20
                <div><div dir=3D"ltr"><div class=3D"ydp55e06c24yqt216441152=
1" id=3D"ydp55e06c24yqtfd93882"><br clear=3D"none">Chandy G schrieb am 12.0=
6.2024 um 09:47:<br clear=3D"none">&gt; Eventhough pg jdbc driver&nbsp; pro=
vides a way to set fetch size to tune<br clear=3D"none">&gt; the driver to =
achieve better throughput, the JVM fails at the driver<br clear=3D"none">&g=
t; level when records of large size (say 200mb each) flows through.<br clea=
r=3D"none">&gt; this forces to reduce the fetch size (if were to operate at=
 a fixed<br clear=3D"none">&gt; Xmx setting of client jvm).</div><br clear=
=3D"none"><br clear=3D"none"><br clear=3D"none">Did you try the driver's "a=
daptive fetch" feature?<br clear=3D"none"><br clear=3D"none"><br clear=3D"n=
one"><a shape=3D"rect" href=3D"https://jdbc.postgresql.org/documentation/us=
e/#connection-parameters" rel=3D"nofollow" target=3D"_blank">https://jdbc.p=
ostgresql.org/documentation/use/#connection-parameters</a><div class=3D"ydp=
55e06c24yqt2164411521" id=3D"ydp55e06c24yqtfd59020"><br clear=3D"none"><br =
clear=3D"none"><br clear=3D"none"><br clear=3D"none"></div></div></div>
            </div>
        </div></body></html>
------=_Part_3406831_664669539.1718262713256--