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 throughpu

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

Re: Toasted column values during replication

2023-07-15 Thread Chandy G
Using pgoutput - aws rds 13* version and seeing this behavior when using it with debezium 2.0.0 version. Best. On Friday, 30 June, 2023 at 12:53:20 pm GMT-7, Laurenz Albe wrote: On Fri, 2023-06-30 at 17:06 +, Chandy G wrote: > For instance :  Can the postgres internal compon

Toasted column values during replication

2023-06-30 Thread Chandy G
Hi PG Users,  We are running into the postgres toasted values showing up in replication slots. We are using debezium and have gone through the following 1. Various options for handling toasted values during replication at the application level.2. Postgres option to turn on replica identitiy to fu