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

From: Sbob <sbob(at)quadratum-braccas(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: significant jump in sql statement timing for on server vs a remote connection
Date: 2022-04-20 15:16:26
Message-ID: 616d2fb0-7964-1aa3-709f-47d2d52e5c90@quadratum-braccas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On 4/19/22 22:17, Jeff Janes wrote:
> On Tue, Apr 19, 2022 at 5:00 PM Sbob <sbob(at)quadratum-braccas(dot)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

Here is the ping stats:

--- db-primary ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3000ms
rtt min/avg/max/mdev = 0.304/0.348/0.400/0.039 ms

This seems pretty good yes?Anything else I could look at?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2022-04-20 15:49:30 Re: Postgresql TPS Bottleneck
Previous Message wakandavision 2022-04-20 06:49:16 Re: Postgresql TPS Bottleneck