Postgres Pro
Downloads
Home   >   mailing lists

Re: significant jump in sql statement timing for on server vs a remote connection - Mailing list pgsql-performance

From Jeff Janes
Subject Re: significant jump in sql statement timing for on server vs a remote connection
Date
Msg-id CAMkU=1y3HcV5yKXHFguRDO5+7HmBtcVdQPfw-eaE-zUQdSSqSQ@mail.gmail.com
Whole thread Raw
In response to significant jump in sql statement timing for on server vs a remote connection  (Sbob <sbob@quadratum-braccas.com>)
Responses Re: significant jump in sql statement timing for on server vs a remote connection  (Sbob <sbob@quadratum-braccas.com>)
List pgsql-performance
Tree view
On Tue, Apr 19, 2022 at 5:00 PM Sbob <sbob@quadratum-braccas.com> 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

pgsql-performance by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: significant jump in sql statement timing for on server vs a remote connection
Next
From:
Date:
Subject: Re: Postgresql TPS Bottleneck