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 Sbob
Subject Re: significant jump in sql statement timing for on server vs a remote connection
Date
Msg-id 616d2fb0-7964-1aa3-709f-47d2d52e5c90@quadratum-braccas.com
Whole thread Raw
In response to Re: significant jump in sql statement timing for on server vs a remote connection  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: significant jump in sql statement timing for on server vs a remote connection  (Ranier Vilela <ranier.vf@gmail.com>)
List pgsql-performance
Tree view


On 4/19/22 22:17, Jeff Janes wrote:
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


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?

pgsql-performance by date:

Previous
From:
Date:
Subject: Re: Postgresql TPS Bottleneck
Next
From: Jeff Janes
Date:
Subject: Re: Postgresql TPS Bottleneck