Re: postgres table statistics

2024-06-13 Thread Chandy G
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 wrote: Chandy G schrieb am 12.06.2024 um 09:47: > Eventhough pg jdbc driver  provides a way to set fetch size to tune > the driver to achieve better throughput, the JVM

Re: postgres table statistics

2024-06-12 Thread Shammat
Chandy G schrieb am 12.06.2024 um 09:47: > Eventhough pg jdbc driver 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

Re: postgres table statistics

2024-06-12 Thread Ron Johnson
On Wed, Jun 12, 2024 at 3:48 AM Chandy G wrote: > Hi, > We have postgres 13.9 running with tables thats got billions of records > of varying sizes. Eventhough pg jdbc driver provides a way to set fetch > size to tune the driver to achieve better throughput, the JVM fails at the > driver level

postgres table statistics

2024-06-12 Thread Chandy G
Hi,   We have postgres 13.9 running with tables thats got billions of records of varying sizes. Eventhough pg jdbc driver  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 throug