Re: significant jump in sql statement timing for on server vs a remote connection

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

 



On Tue, Apr 19, 2022 at 5:00 PM Sbob <sbob@xxxxxxxxxxxxxxxxxxxxx> wrote:

However if we move the file to another server in the same network and
run with a psql -h then it runs for more than 10min.

What is the ping time?  Packet loss? You can't take for granted that the network is good and fast just because they are on the same LAN.

Cheers,

Jeff

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

  Powered by Linux