Re: Low performance between datacenters

2024-07-08 Thread Andrei Lepikhov
On 8/7/2024 01:17, Tamás PAPP wrote: hi All, I am new on the list. I hope someone can give me an adequate answer or good advice about my problem. I have a client (normally a web service, for testing the psql client) in GCP. There is a PSQL server in another DC. The ping response time is 20ms

Re: Low performance between datacenters

2024-07-07 Thread Vitalii Tymchyshyn
Often it happens because of the low batch size for fetching data. This makes client wait unnecessarily while reading rows. I am not sure which client are you using, but in java this can be controlled on per-statement level, see https://jdbc.postgresql.org/documentation/query/ I believe there is al

Re: Low performance between datacenters

2024-07-07 Thread Fernando Hevia
El dom, 7 jul 2024 a la(s) 3:17 p.m., Tamás PAPP (tomposm...@gmail.com) escribió: > hi All, > > I am new on the list. > I hope someone can give me an adequate answer or good advice about my > problem. > > I have a client (normally a web service, for testing the psql client) in > GCP. There is a PS

Low performance between datacenters

2024-07-07 Thread Tamás PAPP
hi All, I am new on the list. I hope someone can give me an adequate answer or good advice about my problem. I have a client (normally a web service, for testing the psql client) in GCP. There is a PSQL server in another DC. The ping response time is 20ms. I measured the bandwidth via scp and it