Re: waiting for client write

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Em sex., 11 de jun. de 2021 às 14:59, Ayub Khan <ayub.hp@xxxxxxxxx> escreveu:
Ranier,

I tried to VACCUM ANALYZE the tables involved multiple times and also tried the statistics approach as well
Ayub you can try by the network side:

https://stackoverflow.com/questions/50298447/postgres-jdbc-client-getting-stuck-at-reading-from-socket

" We found out that this was caused by the database server's MTU setting.
MTU was set to 9000 by default and resulted in packet loss. Changing it to 1500 resolved the issue."

regards,
Ranier Vilela

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux